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
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?
Doug Gorley | doug(at)gorley(dot)ca
pgsql-admin by date
|Next:||From: Joshua D. Drake||Date: 2010-05-22 17:11:23|
|Subject: Re: How can I tell if I'm autovacuuming?|
|Previous:||From: Alex Kogan||Date: 2010-05-22 02:32:34|
|Subject: Jobs not running|