Chris Hoover wrote:
> I turned on autovacuum on one of my database servers over the weekend. I
> have been looking at the logs trying to see what it is doing. However, all
> I see are lines like this:
> ,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
> database "postgres"
>
> Is there a way to tell if autovacuum is actually doing any work?
Yeah, autovacuum is pretty stupid in its logging. You can put
log_min_messages (or min_log_messages, I always forget which one it is)
DEBUG2 to get more detailed messages. You'll get a lot other stuff as
well :-(
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support