xid wraparound

From: Mark Rostron <mrostron(at)ql2(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: xid wraparound
Date: 2010-09-26 00:41:09
Message-ID: FD020D3E50E7FA479567872E5F5F31E3045A05CB90@ex01.corp.ql2.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

When the XID wraps, at the moment it does so, unless you set vacuum_freeze_min_age to 0 and a vacuum has just been performed, is there not a chance that there will be some data loss? If it changes value from (2^32 -1) to (0), it's value is going to be less than SOME rows - the ones which have not been "frozen" and whose XID was presumably greater than (relfrozenid) at the time the wrap occurred - and will they not disappear until they too are frozen?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-09-26 00:53:42 Re: xid wraparound
Previous Message Justin Pitts 2010-09-26 00:04:31 Re: [pgsql-admin] Daily digest v1.3327 (2 messages)