Re: VACUUM and transaction ID wraparound - Mailing list pgsql-general

From Tom Lane
Subject Re: VACUUM and transaction ID wraparound
Date
Msg-id 2297.1053146411@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM and transaction ID wraparound  ("Dean Gibson (DB Administrator)" <dba-sql@ultimeth.net>)
List pgsql-general
"Dean Gibson (DB Administrator)" <dba-sql@ultimeth.net> writes:
> The documentation says (Admin Guide, 8.2.3), "... each database-wide
> VACUUM automatically delivers a warning" if individual tables need
> VACUUMing to prevent transaction ID wraparound.

Not individual tables, but whole databases (databases other than the one
you just vacuumed, obviously).

> Is there something here I don't understand?

The warning is intended to alert you in case you have entire databases
you've forgotten to vacuum for a good long while.  It's a compromise
between being too much in-your-face and letting you go down to
disaster...

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: VACUUM and transaction ID wraparound
Next
From: Tom Lane
Date:
Subject: Re: - what protocol for an Internet postgres