Re: Comparing txid_current() to xmin - Mailing list pgsql-general

From Mike Lewis
Subject Re: Comparing txid_current() to xmin
Date
Msg-id CA+foqsRSqH2wdHCDioVbhQCCbarorGw0Xcnoa1DtLgTHSZV2-Q@mail.gmail.com
Whole thread Raw
In response to Re: Comparing txid_current() to xmin  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Uh, txid_current returns a 64 bit value, whereas xmin only stores the 32
least significant bits.  They would certainly differ after a xid
wraparound.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Ah yes...  That would be a problem.  What about using just the lower 32 bits of the txid_current?

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Comparing txid_current() to xmin
Next
From: Bryan Montgomery
Date:
Subject: Re: Tuning / performance questions