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. > 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
