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.