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
> basis?
No. Needing to do a VACUUM FULL would be prima facie evidence that
autovacuum *isn't* getting its job done.
regards, tom lane