On Wed, Aug 31, 2005 at 09:47:35AM -0400, Tom Lane wrote: > Jeff Frost <jeff@xxxxxxxxxxxxxxxxxxxxxx> writes: > > Since we're on the vacuum kick these days, what's the best way to tell if my > > autovacuum settings are working well? I'm sure I can query some info out of > > the pg_stats tables, no? > > If the database isn't bloating (ie, physical storage growing faster than > valid data volume) then it's getting the job done. Keep an eye on > "du $PGDATA" or pg_class.relpages entries. Another test may be checking table stats with pgstattuple. If the percentage of dead rows grows as time passes, you have a problem. -- Alvaro Herrera <alvherre[]alvh.no-ip.org> Architect, www.EnterpriseDB.com "Puedes vivir solo una vez, pero si lo haces bien, una vez es suficiente"