Re: Add 64-bit XIDs into PostgreSQL 15

Maxim Orlov <orlovmg@gmail.com>

From: Maxim Orlov <orlovmg@gmail.com>
To: Yura Sokolov <y.sokolov@postgrespro.ru>
Cc: Evgeny Voropaev <evgeny.voropaev@tantorlabs.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Andrey Borodin <x4mmm@yandex-team.ru>
Date: 2025-11-25T06:12:16Z
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

Attachments

Here is a rebase @ 4d3f623ea88

The patch set has grown increasingly old. It appears to me that
everything requires to be thoroughly overhauled to bring it up to date.
Especially given that the first patch to be committed switches
multi-offsets to 64-bit and utilizes a different pg_upgrade method.

I am planning to tackle this in the near future and give the patch a
thorough overhaul.
-- 
Best regards,
Maxim Orlov.