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.
