DB Upgrade complete
Mike Bonnet
mikeb at redhat.com
Tue Jul 10 14:59:06 UTC 2007
On Tue, 2007-07-10 at 09:56 -0500, Mike McGrath wrote:
> Mike Bonnet wrote:
> > #---------------------------------------------------------------------------
> >
> > -#autovacuum = off # enable autovacuum subprocess?
> > +autovacuum = on # enable autovacuum subprocess?
> > #autovacuum_naptime = 60 # time between autovacuum runs, in secs
> > #autovacuum_vacuum_threshold = 1000 # min # of tuple updates before
> > # vacuum
>
> With autovacuum on do we still have to run the nightly vacuum jobs?
We'll have to keep an eye on the heavily-updated tables, but autovacuum
combined with the max_fsm_pages increase should remove the need for the
nightly vacuums.
More information about the infrastructure
mailing list