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)