Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B6D669FBF4D for ; Wed, 20 Jun 2007 14:06:53 -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 87379-02 for ; Wed, 20 Jun 2007 14:06:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx1.wp.pl (mx1.wp.pl [212.77.101.5]) by postgresql.org (Postfix) with ESMTP id 8D7A89FBEDF for ; Wed, 20 Jun 2007 14:06:46 -0300 (ADT) Received: (wp-smtpd smtp.wp.pl 14862 invoked from network); 20 Jun 2007 19:06:44 +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 19:06:44 +0200 Message-ID: <46795EA3.8030703@wp.pl> Date: Wed, 20 Jun 2007 19:06:43 +0200 From: Ireneusz Pluta User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Logging autovacuum activity Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit 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/202 X-Sequence-Number: 25870 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