autovacuum and transaction id wraparound

From: pawel_kukawski <kukismen(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: autovacuum and transaction id wraparound
Date: 2012-03-07 20:13:26
Message-ID: 1331151206505-5545412.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a question regarding the following snippet in the official Postgres
documentation:

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

Do you know any real reason why the autovacuum may fail to clear old XIDs?

Is this highly probable ?

Thanks,
Pawel

--
View this message in context: http://postgresql.1045698.n5.nabble.com/autovacuum-and-transaction-id-wraparound-tp5545412p5545412.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-03-07 20:31:32 Re: [GENERAL] Altering a table with a rowtype column
Previous Message Merlin Moncure 2012-03-07 20:11:55 Re: [GENERAL] Altering a table with a rowtype column