Re: Add 64-bit XIDs into PostgreSQL 15
Maxim Orlov <orlovmg@gmail.com>
From: Maxim Orlov <orlovmg@gmail.com>
To: Pavel Borisov <pashkin.elfe@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>,
Aleksander Alekseev <aleksander@timescale.com>, Postgres hackers <pgsql-hackers@lists.postgresql.org>,
Stephen Frost <sfrost@snowman.net>, Alexander Korotkov <aekorotkov@gmail.com>,
Andres Freund <andres@anarazel.de>, Ilya Anfimov <ilan@tzirechnoy.com>
Date: 2022-05-13T13:11:08Z
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 →
-
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
Attachments
- v34-0001-Use-64-bit-numbering-of-SLRU-pages.patch (text/x-patch) patch v34-0001
- v34-0004-Use-64-bit-pages-representation-in-SLRU-callers.patch (text/x-patch) patch v34-0004
- v34-0005-Add-initdb-option-to-initialize-cluster-with-non.patch (text/x-patch) patch v34-0005
- v34-0002-Use-64-bit-format-to-output-XIDs.patch (text/x-patch) patch v34-0002
- v34-0003-Use-64-bit-FullTransactionId-instead-of-Epoch-xi.patch (text/x-patch) patch v34-0003
- v34-0006-README.XID64.patch (text/x-patch) patch v34-0006
- v34-0007-Use-64-bit-GUCs.patch (text/x-patch) patch v34-0007
- v34-0008-Use-64-bit-XIDs.patch (text/x-patch) patch v34-0008
Hi! Here is an updated version of patch. Major changes are: - single out options to initialize cluster with given xid/mxid/mxoff into separate patch 0004 with a purpose of review and apply it separately before the main patch. We also created a separate CF entry to handle this [1]. - add unit tests for lazy page conversion from 32 to 64 bits xid format (inside patch 0008). - make logical replication of xid format to be 64 bit and add test (inside patch 0008). - remove unnecessary padding to compactify XLogRecord - 32 to 64 bit page lazy conversion refactoring - rebase to recent upstream branch Patches 0001-0003 are identical to the v33 from Aleksander Alekseev in thread [2]. [1] https://www.postgresql.org/message-id/flat/CACG=ezaa4vqYjJ16yoxgrpa-=gXnf0Vv3Ey9bjGrRRFN2YyWFQ@mail.gmail.com [2] https://www.postgresql.org/message-id/flat/CAJ7c6TPDOYBYrnCAeyndkBktO0WG2xSdYduTF0nxq%2BvfkmTF5Q%40mail.gmail.com Reviews are very welcome! -- Best regards, Maxim Orlov.