From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Ian Westmacott <ianw@intellivid.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: 8.1.8 autovacuum missing databases
Date: Wed, 30 Apr 2008 12:27:49 -0400
Message-ID: <19778.1209572869@sss.pgh.pa.us> (raw)
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>
Alvaro Herrera <alvherre@commandprompt.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, alvherre@commandprompt.com, ianw@intellivid.com
Subject: Re: 8.1.8 autovacuum missing databases
In-Reply-To: <19778.1209572869@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox