Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum and transaction id wraparound - Mailing list pgsql-general

From Jens Wilke
Subject Re: autovacuum and transaction id wraparound
Date
Msg-id 201203081447.45232.jens.wilke@affinitas.de
Whole thread Raw
In response to autovacuum and transaction id wraparound  (pawel_kukawski <kukismen@gmail.com>)
Responses Re: autovacuum and transaction id wraparound  (pawel_kukawski <kukismen@gmail.com>)
List pgsql-general
Tree view 
On Wednesday 07 March 2012 21:13:26 pawel_kukawski wrote:

Hi,

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

If it's unable to keep up.
Or may be, if there're very long running idle in transactions.

> Is this highly probable ?

postmaster will shutdown to prevent wraparound, if there are fewer than1
million transactions left until wraparound.

Rgds, Jens

pgsql-general by date:

Previous
From: Anssi Kääriäinen
Date:
Subject: Automatic shadow-table management script
Next
From: Andy Colson
Date:
Subject: Re: rounding a timestamp to nearest x seconds