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

Поиск
Список
Период
Сортировка
От Sic Transit Gloria Mundi
Тема Dumb question - how to tell if autovacuum is doing its job in 8.2.x
Дата
Msg-id 36952.75545.qm@web53107.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x  ("Shoaib Mir" <shoaibmir@gmail.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: marcelo Cortez
Дата:
Сообщение: Help with install postgres 8.2 win32 version
Следующее
От: "Mike"
Дата:
Сообщение: Re: Service startup - troubleshooting