Re: Add 64-bit XIDs into PostgreSQL 15

Maxim Orlov <orlovmg@gmail.com>

From: Maxim Orlov <orlovmg@gmail.com>
To: "Finnerty, Jim" <jfinnert@amazon.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2022-01-08T08:21:20Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Add SLRU tests for 64-bit page case

  2. Make use FullTransactionId in 2PC filenames

  3. Use larger segment file names for pg_notify

  4. Index SLRUs by 64-bit integers rather than by 32-bit integers

>
>    Perhaps we can merge some of the code cleanup that it contained, such
> as using XID_FMT everywhere and creating a type for the kind of page
> returned by TransactionIdToPage() to make the code cleaner.
>

Agree, I think this is a good idea.


>     Is your patch functionally the same as the PostgresPro
> implementation?
>

Yes, it is. It basically is PostgresPro implementation, not a concept or
smth.


-- 
Best regards,
Maxim Orlov.