On Sat, 2010-05-22 at 09:51 -0400, Doug Gorley wrote: > From what I see in the docs, these three settings in postgresql.conf > should be enough for PostgreSQL (8.2) to autovacuum with the default > settings: > > autovacuum = on > stats_start_collector = on > stats_row_level = on > > So, two questions: > > (a) Is this correct? Should autovacuum be functional now? If you restarted. > (b) How can I verify that my databases are being vacuumed by autovacuum? pg_stat_user_tables should have a last_autovac column. > > Thanks, > > -- > Doug Gorley | doug@xxxxxxxxx > > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
