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 BCA4D9FA5E1 for ; Wed, 28 Jun 2006 01:47:44 -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 71839-02 for ; Wed, 28 Jun 2006 01:47:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 0705A9FA2F0 for ; Wed, 28 Jun 2006 01:47:39 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 4A86056443; Tue, 27 Jun 2006 23:47:39 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 27 Jun 2006 23:47:38 -0500 Date: Tue, 27 Jun 2006 23:47:38 -0500 From: "Jim C. Nasby" To: Chris Hoover Cc: Tom Lane , "pgsql-admin@postgresql.org" Subject: Re: 8.1.3 - autovacuum question Message-ID: <20060628044737.GP44573@pervasive.com> References: <1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com> <22917.1151355796@sss.pgh.pa.us> <1d219a6f0606270949n6d23144dr1d07ee198ff0c8fc@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1d219a6f0606270949n6d23144dr1d07ee198ff0c8fc@mail.gmail.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060628:revoohc@gmail.com::4NmkJ591ZoMQiVr+:00000000000000000000 0000000000000000000000001gb0 X-Hashcash: 1:20:060628:tgl@sss.pgh.pa.us::iBtpif514bwwSUm6:00000000000000000000 0000000000000000000000006cM4 X-Hashcash: 1:20:060628:pgsql-admin@postgresql.org::u+oS0MQ19VUnUKy6:00000000000 0000000000000000000000004GmF X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/274 X-Sequence-Number: 22236 Yes, and I belive they're in HEAD now. On Tue, Jun 27, 2006 at 12:49:25PM -0400, Chris Hoover wrote: > Are there any plans to fix this so we can see atleast the table activity ( > i.e. vacuuming table x) any time soon? > > Thanks, > > Chris > > On 6/26/06, Tom Lane wrote: > > > >"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 > > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461