Dumb question - how to tell if autovacuum is doing its job in 8.2.x

From: Sic Transit Gloria Mundi <sitrglmu(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dumb question - how to tell if autovacuum is doing its job in 8.2.x
Date: 2007-02-08 21:03:31
Message-ID: 36952.75545.qm@web53107.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I couldnt find this on google, the archives, or the manual. But with the changes to what the autovacuum daemon logs, how can we verify it's doing its thing? Is there a way to query the last time a table was vacuumed? But I don't see that in the system catalog.

Thanks!


---------------------------------
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Edson 2007-02-08 21:32:38 Problems shutting down Postmaster
Previous Message Tom Lane 2007-02-08 20:41:36 Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9