Horton
Menu

Re: Add 64-bit XIDs into PostgreSQL 15

Heikki Linnakangas <hlinnaka@iki.fi>

View thread
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Maxim Orlov <orlovmg@gmail.com>, 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>, Robert Haas <robertmhaas@gmail.com>
Date: 2026-02-07T22:56:55Z
Lists: pgsql-hackers 
On 25/11/2025 08:12, Maxim Orlov wrote:
> -typedef uint32 TransactionId;
> +typedef uint64 TransactionId;

I'm not sure I'm on board with this, BTW. My hunch is this'll be a much 
smaller patch if you mostly stick to 32-bit representation in memory.

- Heikki

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