On Fri, Nov 11, 2011 at 9:59 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> In another thread, Alvaro quoted from the manual:
>>       If for some reason autovacuum fails to clear old XIDs from a table, the
>>       system will begin to emit warning messages like this when the 
>> database's oldest
>>       XIDs reach ten million transactions from the wraparound point:
>
>>       WARNING:  database "mydb" must be vacuumed within 177009986 
>> transactions
>>       HINT:  To avoid a database shutdown, execute a database-wide VACUUM in 
>> "mydb".
>
>>       (A manual VACUUM should fix the problem, as suggested by the hint; but
>>       note that the VACUUM must be performed by a superuser, else it will 
>> fail to
>>       process system catalogs and thus not be able to advance the database's
>>       datfrozenxid.)
>
> It occurs to me to wonder how this scenario will interact with the
> recent changes to let VACUUM skip pages.  AFAIR there is not a way for a
> manual VACUUM to set the anti-wraparound mode, is there?

I tweaked Simon's original patch to address exactly this scenario;
VACUUM FREEZE prevents page-skipping behavior.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to