How can I tell if I'm autovacuuming? - Mailing list pgsql-admin

From Doug Gorley
Subject How can I tell if I'm autovacuuming?
Date
Msg-id 4BF7E14B.6030800@gorley.ca
Whole thread Raw
Responses Re: How can I tell if I'm autovacuuming?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: How can I tell if I'm autovacuuming?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Alex Kogan
Date:
Subject: Jobs not running
Next
From: "Joshua D. Drake"
Date:
Subject: Re: How can I tell if I'm autovacuuming?