On Fri, 2007-12-14 at 09:35 +0100, Harald Armin Massa wrote:
> Ow Mun Heng,
>
> The current issue which prompted me to do such housekeeping is
> due to
> long database wide vacuum time. (it went from 2 hours to 4
> hours to 7
> hours)
>
> If vacuum takes
Ow Mun Heng,
The current issue which prompted me to do such housekeeping is due to
> long database wide vacuum time. (it went from 2 hours to 4 hours to 7
> hours)
>
If vacuum takes to long, you are doing it not often enough. You should use
autovacuum, you should be able to express the delta betw
I'm starting to perform some basic housekeeping to try to trim some big
tables (~200 million rows - ~50GB+indexes) into separate partitions (via
inheritance).
The current issue which prompted me to do such housekeeping is due to
long database wide vacuum time. (it went from 2 hours to 4 hours to 7
