Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id A4E112E0060 for ; Tue, 29 Apr 2008 18:05:11 -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 15373-08-2 for ; Tue, 29 Apr 2008 18:05:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mailhost.intellivid.com (mailhost.intellivid.com [64.32.200.11]) by developer.postgresql.org (Postfix) with ESMTP id F0B7B2E0063 for ; Tue, 29 Apr 2008 18:05:03 -0300 (ADT) Received: from [192.168.2.80] (vega.intellivid.com [192.168.2.80]) by newmail.intellivid.com (Postfix) with ESMTP id 30DA06C69A; Tue, 29 Apr 2008 17:05:05 -0400 (EDT) Subject: Re: 8.1.8 autovacuum missing databases From: Ian Westmacott To: Alvaro Herrera Cc: pgsql-admin@postgresql.org In-Reply-To: <20080429203335.GK5652@alvh.no-ip.org> References: <1209499373.18622.47.camel@vega.intellivid.com> <20080429203335.GK5652@alvh.no-ip.org> Content-Type: text/plain Organization: IntelliVid Corp. Date: Tue, 29 Apr 2008 17:05:03 -0400 Message-Id: <1209503103.18622.68.camel@vega.intellivid.com> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/291 X-Sequence-Number: 29055 On Tue, 2008-04-29 at 16:33 -0400, Alvaro Herrera wrote: > Is autovacuum dying before being able to finish the vacuuming of > template1 or the other database? Not as far as I can tell. There are no indications of any crash or error in the log file (I just bumped the log level up to debug1). Just autovacuum processing template1 or the one other database every minute. I ran VACUUM ANALYZE on both template1 and the one database manually just to make sure there wasn't a lock or something preventing completion, but they both completed without error. --Ian