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 ED98E9FA6B3 for ; Mon, 26 Jun 2006 18:03: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 07837-08 for ; Mon, 26 Jun 2006 18:03:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 0EBB99FA10A for ; Mon, 26 Jun 2006 18:03:22 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k5QL3GH6022918; Mon, 26 Jun 2006 17:03:16 -0400 (EDT) To: "Chris Hoover" cc: "pgsql-admin@postgresql.org" Subject: Re: 8.1.3 - autovacuum question In-reply-to: <1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com> References: <1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com> Comments: In-reply-to "Chris Hoover" message dated "Mon, 26 Jun 2006 16:38:23 -0400" Date: Mon, 26 Jun 2006 17:03:16 -0400 Message-ID: <22917.1151355796@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/243 X-Sequence-Number: 22205 "Chris Hoover" writes: > 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. I think that's all you'll see at the default logging level. There are per-table messages at DEBUG2 level ... which will enable a whole lot of other chatter as well :-( regards, tom lane