From: Nick Fankhauser <nickf@doxpop.com>
To: pgsql-admin@postgresql.org
Subject: Re: Specific questions about wraparound and vacuum
Date: Wed, 8 Aug 2007 22:10:23 -0400
Message-ID: <bb2fe60f0708081910p531c7704tc5e7a1dfa344e8c3@mail.gmail.com> (raw)
In-Reply-To: <11659.1186623487@sss.pgh.pa.us>
References: <bb2fe60f0708080907x1d8aa6dct5aa3cb1e1ba15897@mail.gmail.com>
<bb2fe60f0708080920v44dfa90fp14d8b5867f73cc31@mail.gmail.com>
<11659.1186623487@sss.pgh.pa.us>
On 8/8/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Nick Fankhauser" <nickf@doxpop.com> writes:
> > One other question- when I'm vacuuming, I always get the warning:
>
> > WARNING: some databases have not been vacuumed in <big number> transactions
> > HINT: Better vacuum them within <big number> transactions, or you may
> > have a wraparound failure.
>
> > I get these even after all DBs except template0 have been freshly vacuumed. Why?
>
> Do your vacuums change the pg_database.datfrozenxid values for the
> databases? The only reason I can think of for them not to do so
> is if you're not doing them as superuser ...
>
> regards, tom lane
>
They do change the values- I noted this by selecting age(datfrozenxid)
in template1 both before and after vacuuming and noting the change.
Also, the maintenance process that does the regular vacuum on our
"prod" database is run as user postgres.
Our regular vacuum process only runs on our single "prod" database-
not template1. Is template1 a "frozen" database, or just template0? If
template1 is not frozen, that may explain the warning. Would I get the
warning even if the DB that has not been recently vacuumed has never
had any transactions on it?
-Nick
--
------------------------------------------------------------------
Nick Fankhauser
nickf@doxpop.com
http://www.doxpop.com
765.965.7363
765.962.9788 (Fax)
Doxpop - Public Records at Your Fingertips.
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: nickf@doxpop.com
Subject: Re: Specific questions about wraparound and vacuum
In-Reply-To: <bb2fe60f0708081910p531c7704tc5e7a1dfa344e8c3@mail.gmail.com>
* 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