Re: Add 64-bit XIDs into PostgreSQL 15

Evgeny Voropaev <evorop.wiki@gmail.com>

From: Evgeny Voropaev <evorop.wiki@gmail.com>
To: Maxim Orlov <orlovmg@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2025-06-11T06:00:01Z
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

 > What exactly would break if we did perform `heap_page_prune_execute`
 > with NO fragmentation repair during `heap_page_prepare_for_xid`?

Correction into the last question:

What exactly would break if we did invoke `heap_page_prune_execute` with 
`repairFragmentation=true` during performing of `heap_page_prepare_for_xid`?