Re: xid wraparound

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Rostron <mrostron(at)ql2(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: xid wraparound
Date: 2010-09-26 00:53:42
Message-ID: 17534.1285462422@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mark Rostron <mrostron(at)ql2(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stan Hoeppner 2010-09-26 09:58:29 Re: [NOVICE] - SAN/NAS/DAS - Need advises
Previous Message Mark Rostron 2010-09-26 00:41:09 xid wraparound