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?
(b) How can I verify that my databases are being vacuumed by autovacuum?
Thanks,
--
Doug Gorley | doug@gorley.ca