Re: Vacuum Vs Vacuum Full

Adrian Klaver wrote:
> On Monday 04 August 2008 11:04:00 pm Robert Shaw wrote:
>> "WARNING:  database "mydb" must be vacuumed within 177009986 transactions
>> HINT:  To avoid a database shutdown, execute a full-database VACUUM in
>> "mydb"."Which is reason I ask the question, is full vacuum backup useful
>> for anything other than reclaiming disk space.
>
> Actually its not asking for a VACUUM FULL but a VACUUM of the full database,
> instead of selected tables.
>
> See below for complete details
> http://www.postgresql.org/docs/8.3/interactive/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND


BTW, what version of PostgreSQL is this?  Database-wide vacuum is no
longer required for XID wraparound issues.  I think this was an 8.3
change but might have happened in 8.2, I don't remember.

Matt