X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 392909FA7B6 for ; Mon, 26 Jun 2006 17:38:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11659-01 for ; Mon, 26 Jun 2006 17:38:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.202]) by postgresql.org (Postfix) with ESMTP id 8DA419FA6B3 for ; Mon, 26 Jun 2006 17:38:25 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s13so953053wxc for ; Mon, 26 Jun 2006 13:38:24 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=Fc9Yn517sdiK0iRqBBjgvDQCzEQCWiWcTAsB8npeC2R8x1tMsVgZCTcVtdXWLbvxSprqBTM3lHyGDudNE62ETjmhOeUBT7OfT04G8g3GbCyXKNWvAk1ws28KNbZGDoCoIl3CevhmQoWPOv00bUEgJHtBHlt6cIf5Jr98lo0kqGI= Received: by 10.70.71.4 with SMTP id t4mr9154063wxa; Mon, 26 Jun 2006 13:38:23 -0700 (PDT) Received: by 10.70.73.15 with HTTP; Mon, 26 Jun 2006 13:38:23 -0700 (PDT) Message-ID: <1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com> Date: Mon, 26 Jun 2006 16:38:23 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: 8.1.3 - autovacuum question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_84414_27114800.1151354303663" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/239 X-Sequence-Number: 22201 ------=_Part_84414_27114800.1151354303663 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_84414_27114800.1151354303663 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_84414_27114800.1151354303663--