pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.



view thread (11+ messages)  latest in thread

Message-ID: <bb2fe60f0708081910p531c7704tc5e7a1dfa344e8c3@mail.gmail.com>
Permalink:  ../bb2fe60f0708081910p531c7704tc5e7a1dfa344e8c3@mail.gmail.com/
Also on:    postgresql.org/message-id/bb2fe60f0708081910p531c7704tc5e7a1dfa344e8c3@mail.gmail.com

 · 

reply

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