Re: 8.1.3 - autovacuum question

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