Re: Vacuum Vs Vacuum Full - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum Vs Vacuum Full
Date
Msg-id 10052.1217954208@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum Vs Vacuum Full  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: Vacuum Vs Vacuum Full  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-general
"Matthew T. O'Connor" <matthew@zeut.net> writes:
>> 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".

> 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.

8.2.  But you could still get that message, even in CVS HEAD, if
autovacuum was failing to complete for some reason (and had been
failing for quite a long time).

            regards, tom lane

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: replication only
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Vacuum Vs Vacuum Full