Re: autovacuum not working?

On Mon, Oct 09, 2006 at 09:27:30AM -0500, Medora Schauer wrote:
> > From your attached config file:
> >
> > #autovacuum_vacuum_threshold = 1000    # min # of tuple updates before
> >                     # vacuum
> >
>
> Yup, that was it.

Actually, not quite.

Vacuum will update relpages and reltuples, but it won't update other
stats. That's what analyze does (autovacuum_analyze_threshold). By
default, that's set to 500; I'll typically drop it to 200 or so (keep in
mind that analyze is much cheaper than vacuum).
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)