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 |
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 |