[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: DB Upgrade complete



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.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]