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
