Re: Comparing txid_current() to xmin

From: Mike Lewis <mikelikespie(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Comparing txid_current() to xmin
Date: 2012-11-07 02:35:46
Message-ID: CA+foqsRSqH2wdHCDioVbhQCCbarorGw0Xcnoa1DtLgTHSZV2-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryan Montgomery 2012-11-07 05:29:39 Re: Tuning / performance questions
Previous Message Alvaro Herrera 2012-11-07 02:10:19 Re: Comparing txid_current() to xmin