Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id A4A1E2E003B for ; Wed, 30 Apr 2008 13:28:03 -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 16333-04 for ; Wed, 30 Apr 2008 13:27:54 -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 7F7752E002D for ; Wed, 30 Apr 2008 13:27:54 -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 m3UGRnWe019779; Wed, 30 Apr 2008 12:27:49 -0400 (EDT) To: Alvaro Herrera cc: Ian Westmacott , pgsql-admin@postgresql.org Subject: Re: 8.1.8 autovacuum missing databases In-reply-to: <20080430161942.GC21286@alvh.no-ip.org> 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> Comments: In-reply-to Alvaro Herrera message dated "Wed, 30 Apr 2008 12:19:42 -0400" Date: Wed, 30 Apr 2008 12:27:49 -0400 Message-ID: <19778.1209572869@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/310 X-Sequence-Number: 29074 Alvaro Herrera writes: > Right -- if you have two databases over the wraparound edge, it will > alternate between them. > I still think that the autovac is dying before completing the task. Did > you investigate whether there are "ERROR" messages coming from > autovacuum? No PG crashes would happen. AFAICS, if it's triggering a whole_db run and the run fails to get to the point of updating pg_database, then the next run will pick the very same db. 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? regards, tom lane