On Wed, Aug 31, 2005 at 09:47:35AM -0400, Tom Lane wrote:
> Jeff Frost <[EMAIL PROTECTED]> 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"
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
