Re: Should we add xid_current() or a int8->xid cast? - Mailing list pgsql-hackers

From Mark Dilger
Subject Re: Should we add xid_current() or a int8->xid cast?
Date
Msg-id B7D88DC1-DDB5-4220-A118-7912C26CBD29@enterprisedb.com
Whole thread Raw
In response to Re: Should we add xid_current() or a int8->xid cast?  (Andres Freund <andres@anarazel.de>)
Responses Re: Should we add xid_current() or a int8->xid cast?  (James Coleman <jtc331@gmail.com>)
Re: Should we add xid_current() or a int8->xid cast?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers

> On Apr 2, 2020, at 11:01 AM, Andres Freund <andres@anarazel.de> wrote:
>
>>
>> Hmm, for some reason I had it in my head that we would make these use an
>> "epoch/val" output format rather than raw uint64 values.
>
> Why would we do that? IMO the goal should be to reduce awareness of the
> 32bitness of normal xids from as many places as possible, and treat them
> as an internal space optimization.

I agree with transitioning to 64-bit xids with 32 bit xid/epoch pairs as an internal implementation and storage detail
only,but we still have user facing views that don't treat it that way.   pg_stat_get_activity still returns backend_xid
andbackend_xmin as 32-bit, not 64-bit.  Should this function change to be consistent?  I'm curious what the user
experiencewill be during the transitional period where some user facing xids are 64 bit and others (perhaps the same
xidsbut viewed elsewhere) will be 32 bit.  That might make it difficult for users to match them up. 

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company






pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: snapshot too old issues, first around wraparound and then more.
Next
From: Tom Lane
Date:
Subject: Re: control max length of parameter values logged