VACUUM and transaction ID wraparound

From: "Dean Gibson (DB Administrator)" <dba-sql(at)ultimeth(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: VACUUM and transaction ID wraparound
Date: 2003-05-17 04:11:19
Message-ID: 5.1.0.14.2.20030516210540.02f6f5b0@dba-sql.ultimeth.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

But I thought a database-wide VACUUM automatically VACUUMed each table in the database (Ref Manual, 'VACUUM'), making (at least to my way of thinking) VACUUMing an individual table unnecessary, and thus making the warning superfluous.

Is there something here I don't understand?

-- Dean

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-05-17 04:34:19 Re: VACUUM and transaction ID wraparound
Previous Message Martijn van Oosterhout 2003-05-17 03:53:20 Re: priority on a process