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.
> Also, if using autovacuum, should I still do a vacuum full on a regular
No. Needing to do a VACUUM FULL would be prima facie evidence that
autovacuum *isn't* getting its job done.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Alvaro Herrera||Date: 2005-08-31 14:40:09|
|Subject: Re: auto vacuum settings|
|Previous:||From: MG||Date: 2005-08-31 11:42:31|
|Subject: Question to localization|