Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A49B82E004A for ; Wed, 30 Apr 2008 14:07:20 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17720-04 for ; Wed, 30 Apr 2008 14:07:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 1E9C42E0041 for ; Wed, 30 Apr 2008 14:07:16 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m3UH7DWV020186; Wed, 30 Apr 2008 13:07:13 -0400 (EDT) To: Ian Westmacott cc: Alvaro Herrera , pgsql-admin@postgresql.org Subject: Re: 8.1.8 autovacuum missing databases In-reply-to: <1209574908.22509.6.camel@vega.intellivid.com> 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> Comments: In-reply-to Ian Westmacott message dated "Wed, 30 Apr 2008 13:01:48 -0400" Date: Wed, 30 Apr 2008 13:07:13 -0400 Message-ID: <20185.1209575233@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/312 X-Sequence-Number: 29076 Ian Westmacott writes: >> I'm noticing though that the 8.1 logic pays attention to both >> datvacuumxid and datfrozenxid. Could we see the age() of both of >> those columns for all the databases. > The are all identical: Oh, that's really strange. Could we see select ctid,xmin,* from pg_database regards, tom lane