On Wed, Aug 31, 2005 at 09:47:35AM -0400, Tom Lane wrote:
> Jeff Frost <jeff(at)frostconsultingllc(dot)com> 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 <alvherrealvh.no-ip.org> Architect, www.EnterpriseDB.com
"Puedes vivir solo una vez, pero si lo haces bien, una vez es suficiente"
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-08-31 14:47:13|
|Subject: Re: Question to localization |
|Previous:||From: Tom Lane||Date: 2005-08-31 13:47:35|
|Subject: Re: auto vacuum settings |