Re: autovacuum and transaction id wraparound

From: Jens Wilke <jens(dot)wilke(at)affinitas(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum and transaction id wraparound
Date: 2012-03-08 13:47:44
Message-ID: 201203081447.45232.jens.wilke@affinitas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2012-03-08 14:17:27 Re: rounding a timestamp to nearest x seconds
Previous Message Anssi Kääriäinen 2012-03-08 11:59:36 Automatic shadow-table management script