xid wraparound - Mailing list pgsql-admin

From Mark Rostron
Subject xid wraparound
Date
Msg-id FD020D3E50E7FA479567872E5F5F31E3045A05CB90@ex01.corp.ql2.com
Whole thread Raw
Responses Re: xid wraparound
List 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?

 

pgsql-admin by date:

Previous
From: Justin Pitts
Date:
Subject: Re: [pgsql-admin] Daily digest v1.3327 (2 messages)
Next
From: Tom Lane
Date:
Subject: Re: xid wraparound