Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 50F5C2E004A for ; Wed, 30 Apr 2008 14:28:12 -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 26285-06 for ; Wed, 30 Apr 2008 14:28:06 -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 726612E002D for ; Wed, 30 Apr 2008 14:28:08 -0300 (ADT) Received: from [192.168.2.80] (vega.intellivid.com [192.168.2.80]) by newmail.intellivid.com (Postfix) with ESMTP id B578D6C637; Wed, 30 Apr 2008 13:28:09 -0400 (EDT) Subject: Re: 8.1.8 autovacuum missing databases From: Ian Westmacott To: Tom Lane Cc: Alvaro Herrera , pgsql-admin@postgresql.org In-Reply-To: <20185.1209575233@sss.pgh.pa.us> References: <1209499373.18622.47.camel@vega.intellivid.com> <20080429203335.GK5652@alvh.no-ip.org> <1209503103.18622.68.camel@vega.intellivid.com> <20080429211244.GM5652@alvh.no-ip.org> <1209560546.5209.12.camel@vega.intellivid.com> <20080430161942.GC21286@alvh.no-ip.org> <19778.1209572869@sss.pgh.pa.us> <1209574908.22509.6.camel@vega.intellivid.com> <20185.1209575233@sss.pgh.pa.us> Content-Type: text/plain Organization: IntelliVid Corp. Date: Wed, 30 Apr 2008 13:28:08 -0400 Message-Id: <1209576488.22509.9.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/313 X-Sequence-Number: 29077 On Wed, 2008-04-30 at 13:07 -0400, Tom Lane wrote: > Oh, that's really strange. Could we see > > select ctid,xmin,* from pg_database itvtrackdata=> select ctid,xmin,* from pg_database; ctid | xmin | datname | datdba | encoding | datistemplate | datallowconn | datconnlimit | datlastsysoid | datvacuumxid | datfrozenxid | dattablespace | datconfig | datacl -------+----------+------------------+--------+----------+---------------+--------------+--------------+---------------+--------------+--------------+---------------+-----------+------------------------ (0,1) | 564 | postgres | 10 | 6 | f | t | -1 | 10792 | 499 | 499 | 1663 | | (0,2) | 577 | itvtrackdata | 16384 | 6 | f | t | -1 | 10792 | 499 | 499 | 1663 | | (0,3) | 605 | itvtrackdatauser | 16384 | 6 | f | t | -1 | 10792 | 499 | 499 | 1663 | | (0,5) | 18350176 | itvtrackdatapos | 16384 | 6 | f | t | -1 | 10792 | 499 | 499 | 1663 | | (0,6) | 557 | template1 | 10 | 6 | t | t | -1 | 10792 | 499 | 499 | 1663 | | {postgres=CT/postgres} (0,7) | 558 | template0 | 10 | 6 | t | f | -1 | 10792 | 499 | 499 | 1663 | | {postgres=CT/postgres} (6 rows) itvtrackdata=> --Ian