Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id B19682E0041 for ; Wed, 30 Apr 2008 17:44:06 -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 83367-06 for ; Wed, 30 Apr 2008 17:43:59 -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 B1A1F2E009F for ; Wed, 30 Apr 2008 17:44:01 -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 m3UKhvXe022094; Wed, 30 Apr 2008 16:43:57 -0400 (EDT) To: Ian Westmacott cc: Alvaro Herrera , pgsql-admin@postgresql.org Subject: Re: 8.1.8 autovacuum missing databases In-reply-to: <1209576488.22509.9.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> <20185.1209575233@sss.pgh.pa.us> <1209576488.22509.9.camel@vega.intellivid.com> Comments: In-reply-to Ian Westmacott message dated "Wed, 30 Apr 2008 13:28:08 -0400" Date: Wed, 30 Apr 2008 16:43:57 -0400 Message-ID: <22093.1209588237@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/320 X-Sequence-Number: 29084 Ian Westmacott writes: > 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) 499 is the value that those columns would have immediately after initdb, in an 8.1 database. So what this says is that vacuum has never succeeded in updating the values at all, in any of your databases. It definitely *should* be doing that given the size of the age() values you're reporting. Moreover, after a look through the 8.1.8 source code I cannot see how it would not update the values without throwing an ERROR or at least a WARNING into the postmaster log. (What have you got log_min_messages set to, anyway? Maybe the complaint is getting suppressed?) regards, tom lane