From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ian Westmacott <ianw@intellivid.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: 8.1.8 autovacuum missing databases
Date: Wed, 30 Apr 2008 16:43:57 -0400
Message-ID: <22093.1209588237@sss.pgh.pa.us> (raw)
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>
Ian Westmacott <ianw@intellivid.com> 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
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, ianw@intellivid.com, alvherre@commandprompt.com
Subject: Re: 8.1.8 autovacuum missing databases
In-Reply-To: <22093.1209588237@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