Re: Specific questions about wraparound and vacuum

From: "Nick Fankhauser" <nickf(at)doxpop(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Specific questions about wraparound and vacuum
Date: 2007-08-08 16:20:07
Message-ID: bb2fe60f0708080920v44dfa90fp14d8b5867f73cc31@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 8/8/07, Nick Fankhauser <nickf(at)doxpop(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stefan Zweig 2007-08-08 16:25:58 use replication on a database only on selected schemes?
Previous Message Nick Fankhauser 2007-08-08 16:07:14 Specific questions about wraparound and vacuum