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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
