8.1.3 - autovacuum question - Mailing list pgsql-admin

From Chris Hoover
Subject 8.1.3 - autovacuum question
Date
Msg-id 1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com
Whole thread Raw
Responses Re: 8.1.3 - autovacuum question  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: 8.1.3 - autovacuum question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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?  As far as I can see, it is running, but has not done any work.  Thanks for any help on tracking what autovacuum is doing.

Chris

pgsql-admin by date:

Previous
From: "Rodrigo Sakai"
Date:
Subject: RES: Hiding table structure information
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Re: Using PostgreSQL and MIcrosoft SQLServer on the same server