Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D45AF9FB75A for ; Wed, 20 Jun 2007 15:41:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 16434-07 for ; Wed, 20 Jun 2007 15:41:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mx1.wp.pl (mx1.wp.pl [212.77.101.5]) by postgresql.org (Postfix) with ESMTP id A66859FA238 for ; Wed, 20 Jun 2007 15:41:06 -0300 (ADT) Received: (wp-smtpd smtp.wp.pl 8150 invoked from network); 20 Jun 2007 20:41:04 +0200 Received: from ip-213-17-164-70.netia.com.pl (HELO [127.0.0.1]) (ipluta@[213.17.164.70]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with SMTP for ; 20 Jun 2007 20:41:04 +0200 Message-ID: <467974BF.4060809@wp.pl> Date: Wed, 20 Jun 2007 20:41:03 +0200 From: Ireneusz Pluta User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: Sibte Abbas CC: pgsql-admin@postgresql.org Subject: Re: Logging autovacuum activity References: <46795EA3.8030703@wp.pl> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A. X-WP-SPAM: NO 0000000 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/208 X-Sequence-Number: 25876 Sibte Abbas napisaƂ(a): > On 6/20/07, Ireneusz Pluta wrote: >> Hello, >> >> How can I make sure that autovacuum is running, beyond believing that >> all autovacuum_ settings in >> postgresql.conf are set correctly? >> >> In the 8.1 I could see: >> LOG: autovacuum: processing database "test" >> in the log. >> >> But I can't find it in the 8.2.4. >> >> I could see some developers discussions about making changes to >> logging autovacuum activity, however >> could not track the discussion tight enough to find what the final >> solution is. >> >> Thanks >> >> Ireneusz Pluta >> >> > > ps -ef | grep autovacuum. > It does not show it. I run freebsd, does it matter? Anyway, I found that I may enable logging autovacuum messages by setting: log_min_messages = debug1 in postgresql.conf I found it from postgresql-8.2.4/src/backend/postmaster/autovacuum.c, where I read in line 420: ereport(DEBUG1, (errmsg("autovacuum: processing database \"%s\"", db->name))); and this is what the developers were discussing and I did not understand initially. Sorry for the noise. Ireneusz Pluta