Re: Add 64-bit XIDs into PostgreSQL 15

From: Maxim Orlov <orlovmg(at)gmail(dot)com>
To: Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Aleksander Alekseev <aleksander(at)timescale(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Ilya Anfimov <ilan(at)tzirechnoy(dot)com>
Subject: Re: Add 64-bit XIDs into PostgreSQL 15
Date: 2022-05-13 13:11:08
Message-ID: CACG=ezZ96DAnVOC6DkbQVPJE+Q2s-JoaFERXWL0SsDcaRg8Wsg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)mail(dot)gmail(dot)com
[2]
https://www.postgresql.org/message-id/flat/CAJ7c6TPDOYBYrnCAeyndkBktO0WG2xSdYduTF0nxq%2BvfkmTF5Q%40mail.gmail.com

Reviews are very welcome!

--
Best regards,
Maxim Orlov.

Attachment Content-Type Size
v34-0001-Use-64-bit-numbering-of-SLRU-pages.patch text/x-patch 24.5 KB
v34-0004-Use-64-bit-pages-representation-in-SLRU-callers.patch text/x-patch 23.6 KB
v34-0005-Add-initdb-option-to-initialize-cluster-with-non.patch text/x-patch 24.5 KB
v34-0002-Use-64-bit-format-to-output-XIDs.patch text/x-patch 121.3 KB
v34-0003-Use-64-bit-FullTransactionId-instead-of-Epoch-xi.patch text/x-patch 18.7 KB
v34-0006-README.XID64.patch text/x-patch 7.2 KB
v34-0007-Use-64-bit-GUCs.patch text/x-patch 25.8 KB
v34-0008-Use-64-bit-XIDs.patch text/x-patch 683.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Japin Li 2022-05-13 13:13:59 Re: Backends stunk in wait event IPC/MessageQueueInternal
Previous Message Robert Haas 2022-05-13 13:10:52 Re: Add WAL recovery messages with log_wal_traffic GUC (was: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display)