Re: Add 64-bit XIDs into PostgreSQL 15

From: Evgeny <evorop(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add 64-bit XIDs into PostgreSQL 15
Date: 2024-12-08 17:17:17
Message-ID: 51feb92c-3a84-4d40-8d13-ffd523acd877@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

**

*Hello! *

*

The next edition of the xid64 patch has been implemented.

In the presented  version:

1) gathered patches MXIDOFFSETv9 [1], GUC64v2 [2], xid64 (v52-v55) (the
latest versions from the relevant threads have been used);

2) the resulted patches have been rebased onto the current master
(3f9b9621766);

3) implemented the HeapTupleCopyRawXidsFromPage. This function avoids
substitution of xids and returns their real values even in a case of a
frozen tuple;

4) fixed issues revealed by tests;

5) in addition, fixed the "stale xid64" problem at the
heapam_tuple_satisfies_snapshot function. This issue mostly appeared in
practice as the "missing chunk" error during operations on TOASTs of the
pg_statistic table.

*

**

*Looking forward to cooperation and review,*

*

Evgeny Voropaev,

TantorLabs, LLC.

<evorop(at)gmail(dot)com>

<evgeny(dot)voropaev(at)tantorlabs(dot)ru>

*

**

*[1] MXIDOFFSETv9 -
https://www.postgresql.org/message-id/CACG%3Dezajc_Pcqmy6fcq-N8%2BLzCRMzOzJzez2_BgHEu-6RVJtKQ%40mail.gmail.com*

**

**

*[2] GUC64v2 -
https://www.postgresql.org/message-id/4c0c1924-a68c-4b3f-bf81-5af13b1a9087%40gmail.com*

**

**

**

**

Attachment Content-Type Size
v56-0001-Use-64-bit-format-output-for-multixact-offsets.patch text/x-patch 9.0 KB
v56-0002-Use-64-bit-multixact-offsets.patch text/x-patch 13.0 KB
v56-0003-Make-pg_upgrade-convert-multixact-offsets.patch text/x-patch 17.9 KB
v56-0004-Get-rid-of-MultiXactMemberFreezeThreshold-call.patch text/x-patch 8.8 KB
v56-0005-Support-64-bit-integer-GUCs.patch text/x-patch 44.9 KB
v56-0006-Use-64-bit-format-to-output-XIDs.patch text/x-patch 138.8 KB
v56-0007-Use-64-bit-FullTransactionId-instead-of-Epoch-xi.patch text/x-patch 22.2 KB
v56-0008-Use-64-bit-SLRU-pages-in-callers.patch text/x-patch 4.1 KB
v56-0009-Use-64-bit-XIDs.patch text/x-patch 706.9 KB
v56-0010-Add-initdb-option-to-initialize-cluster-with-non.patch text/x-patch 38.2 KB
v56-0011-README.XID64.patch text/x-patch 7.2 KB
v56-0012-Fixed-the-stale-xid64-problem-at-the-heapam_tupl.patch text/x-patch 2.4 MB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2024-12-08 18:32:40 Re: proposal: schema variables
Previous Message Andres Freund 2024-12-08 16:37:37 Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table