Re: DB Upgrade complete

[Mike Bonnet <mikeb redhat com>]

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.