Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)

Aleksander Alekseev <aleksander@timescale.com>

From: Aleksander Alekseev <aleksander@timescale.com>

To: Postgres hackers <pgsql-hackers@lists.postgresql.org>

Cc: Ian Lawrence Barwick <barwick@gmail.com>, Maxim Orlov <orlovmg@gmail.com>, Simon Riggs <simon.riggs@enterprisedb.com>, Hamid Akhtar <hamid.akhtar@percona.com>, Pavel Borisov <pashkin.elfe@gmail.com>, Justin Pryzby <pryzby@telsasoft.com>, Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Japin Li <japinli@hotmail.com>, Alexander Korotkov <aekorotkov@gmail.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Ilya Anfimov <ilan@tzirechnoy.com>

Date: 2022-11-16T08:37:20Z

Lists: pgsql-hackers

Attachments

v45-0003-Use-64-bit-FullTransactionId-instead-of-Epoch-xi.patch (application/octet-stream) patch v45-0003
v45-0001-Use-64-bit-numbering-of-SLRU-pages.patch (application/octet-stream) patch v45-0001
v45-0002-Use-64-bit-format-to-output-XIDs.patch (application/octet-stream) patch v45-0002

Hi Ian,

> I've set the CF entry back to "Ready for Committer",

Thanks. Here is the rebased patchset.

Dilip asked a good question above about the rest of the 64-bit XIDs
patches. I'm going to do some testing and post the results to the main
64-bit XIDs thread [1].

[1]: https://www.postgresql.org/message-id/CAJ7c6TOkpJi78A9chR-j0OOMvP6G%3DuR%2BscpEKsM4jtw0dK9-3Q%40mail.gmail.com

-- 
Best regards,
Aleksander Alekseev

Commits

Fix more holes with SLRU code in need of int64 for segment numbers
- b7935bc10b78 17.0 landed
- bd06cc338d82 18.0 landed
- e367a413b09f 17.0 landed
- c9e24573905b 18.0 landed
Use more consistently int64 for page numbers in SLRU-related code
- 165ea79a6077 17.0 landed
- 3937cadfd438 18.0 landed
Improve comments in slru.{c,h} about segment name format
- 3b279d89cb5c 17.0 landed
- ffb060392961 18.0 landed
Reorder actions in ProcArrayApplyRecoveryInfo()
- c64086b79dba 17.0 landed
Fix typo in 5a1dfde8334b
- ae2ccf66a261 17.0 landed
Fix warning due non-standard inline declaration in 4ed8f0913bfdb5f355
- b589f211e025 17.0 landed
Add SLRU tests for 64-bit page case
- a60b8a58f435 17.0 landed
Make use FullTransactionId in 2PC filenames
- 5a1dfde8334b 17.0 landed
Use larger segment file names for pg_notify
- 2cdf131c46e6 17.0 landed
Index SLRUs by 64-bit integers rather than by 32-bit integers
- 4ed8f0913bfd 17.0 landed
Keep track of transaction commit timestamps
- 73c986adde5d 9.5.0 cited
Handle 5-char filenames in SlruScanDirectory
- 638cf09e76d7 9.4.0 cited