X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E7D8ADA033 for ; Wed, 9 Nov 2005 16:01:54 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46969-10 for ; Wed, 9 Nov 2005 20:01:52 +0000 (GMT) X-Greylist: delayed 03:12:20.600373 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 7414AD9EC8 for ; Wed, 9 Nov 2005 16:01:52 -0400 (AST) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr2.postgresql.org (Postfix) with ESMTP id 7BFB2F0C1B for ; Wed, 9 Nov 2005 16:49:31 +0000 (GMT) Received: from ool-4350c7ad.dyn.optonline.net ([67.80.199.173] helo=[192.168.0.91]) by outbound.mailhop.org with esmtpa (Exim 4.51) id 1EZt8b-000FzW-FM; Wed, 09 Nov 2005 11:49:29 -0500 X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 67.80.199.173 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut Message-ID: <4372281E.60201@zeut.net> Date: Wed, 09 Nov 2005 11:47:26 -0500 From: "Matthew T. O'Connor" User-Agent: Thunderbird 1.4 (Windows/20050908) MIME-Version: 1.0 To: Joe Maldonado Cc: pgsql-admin@postgresql.org Subject: Re: autovacuum daemon question... References: <824355640511090720l27eabde8r61573e574f4904ab@mail.gmail.com> In-Reply-To: <824355640511090720l27eabde8r61573e574f4904ab@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.003 required=5 tests=[AWL=0.003] X-Spam-Score: 0.003 X-Spam-Level: X-Archive-Number: 200511/98 X-Sequence-Number: 19471 Joe Maldonado wrote: > I have not seen any information so far on this but is there a way to > get the autovacuum daemon in PostgreSQL 8.1 to log the tables which it > is perfoming vacuum or analyze operation on? I think the autovacuum daemon does log it's activity however all it's output is set at DEBUG2 or DEBUG3, so you would have to turn up the logging settings for the whole postmaster in order to see it. I think perhaps these should be INFO or something a little more common.