VACUUM and transaction ID wraparound - Mailing list pgsql-general

From Dean Gibson (DB Administrator)
Subject VACUUM and transaction ID wraparound
Date
Msg-id 5.1.0.14.2.20030516210540.02f6f5b0@dba-sql.ultimeth.net
Whole thread Raw
Responses Re: VACUUM and transaction ID wraparound  (Martijn van Oosterhout <kleptog@svana.org>)
Re: VACUUM and transaction ID wraparound  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
The documentation says (Admin Guide, 8.2.3), "... each database-wide VACUUM automatically delivers a warning" if
individualtables 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
(atleast 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


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: priority on a process
Next
From: Martijn van Oosterhout
Date:
Subject: Re: VACUUM and transaction ID wraparound