Postgres Pro
Downloads
Home   >   mailing lists

Re: Specific questions about wraparound and vacuum - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: Specific questions about wraparound and vacuum
Date
Msg-id bb2fe60f0708080920v44dfa90fp14d8b5867f73cc31@mail.gmail.com
Whole thread Raw
In response to Specific questions about wraparound and vacuum  ("Nick Fankhauser" <nickf@doxpop.com>)
Responses Re: Specific questions about wraparound and vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
On 8/8/07, Nick Fankhauser <nickf@doxpop.com> wrote:

> the largest containing rows.

Oops- I meant to say "...the largest containing 56 million rows".

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?

-Nick

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Specific questions about wraparound and vacuum
Next
From: Stefan Zweig
Date:
Subject: use replication on a database only on selected schemes?