Re: xid wraparound - Mailing list pgsql-admin

From Tom Lane
Subject Re: xid wraparound
Date
Msg-id 17534.1285462422@sss.pgh.pa.us
Whole thread Raw
In response to xid wraparound  (Mark Rostron <mrostron@ql2.com>)
Responses Re: xid wraparound  (Mark Rostron <mrostron@ql2.com>)
List pgsql-admin
Mark Rostron <mrostron@ql2.com> writes:
> 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?

No.  XID comparisons are modulo 2^31.

            regards, tom lane

pgsql-admin by date:

Previous
From: Mark Rostron
Date:
Subject: xid wraparound
Next
From: Stan Hoeppner
Date:
Subject: Re: [NOVICE] - SAN/NAS/DAS - Need advises