Re: Add 64-bit XIDs into PostgreSQL 15

Evgeny Voropaev <evgeny.voropaev@tantorlabs.com>

From: Evgeny Voropaev <evgeny.voropaev@tantorlabs.com>
To: wenhui qiu <qiuwenhuifx@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Evgeny <evorop@gmail.com>
Date: 2025-03-26T14:39:52Z
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

Hello hackers!

The actual version of the xid64 patch is attached. The patch has been 
rebased onto the master branch (1eb399366ed, 2025-03-26).
This version fixes several bugs found since December 2024.
1. Fixed the error that occurred when parsing an XLog record in the 
DecodeUpdate function. The error occurred when XLOG_HEAP_INIT_PAGE flag 
was set.

2. Bugs related to page inconsistencies after a prune_freeze operation.
  - fixed the bug of the XMAX_COMMITTED hint bit.
  - fixed the error "An unsaved xmax at a freezing during a replication."

Best regards,
Evgeny Voropaev, Tantor Labs.