Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id D96B62E004D for ; Tue, 29 Apr 2008 17:34:13 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 10689-06 for ; Tue, 29 Apr 2008 17:34:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by developer.postgresql.org (Postfix) with ESMTP id 977922E0060 for ; Tue, 29 Apr 2008 17:34:07 -0300 (ADT) Received: from perhan.alvh.no-ip.org (200-126-123-196.bk8-dsl.surnet.cl [200.126.123.196]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m3TKYGIM003891 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 29 Apr 2008 13:34:19 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 55F6C47C5B; Tue, 29 Apr 2008 16:33:35 -0400 (CLT) Date: Tue, 29 Apr 2008 16:33:35 -0400 From: Alvaro Herrera To: Ian Westmacott Cc: pgsql-admin@postgresql.org Subject: Re: 8.1.8 autovacuum missing databases Message-ID: <20080429203335.GK5652@alvh.no-ip.org> References: <1209499373.18622.47.camel@vega.intellivid.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1209499373.18622.47.camel@vega.intellivid.com> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 29 Apr 2008 13:34:19 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/289 X-Sequence-Number: 29053 Ian Westmacott wrote: > I have a Postgres 8.1.8 system with three databases. Although > autovacuum is enabled (I'm using all default autovacuum configuration > settings) and pg_autovacuum is empty, the logs indicate that only > template1 and one of the three databases are being processed by > autovacuum. Are there other reasons why the other two databases might > be skipped, or some way I could diagnose the issue? Is autovacuum dying before being able to finish the vacuuming of template1 or the other database? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.