8.1.3 - autovacuum question

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: 8.1.3 - autovacuum question
Date: 2006-06-26 20:38:23
Message-ID: 1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2006-06-26 20:44:25 Re: Using PostgreSQL and MIcrosoft SQLServer on the same server
Previous Message Rodrigo Sakai 2006-06-26 20:24:39 RES: Using PostgreSQL and MIcrosoft SQLServer on the same server