| From: | Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> |
|---|---|
| To: | Maxim Orlov <orlovmg(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-06-07 14:15:30 |
| Message-ID: | CALT9ZEGpr3WEPFJL_EHtzE-vF09SPYeAVyoPYZUuG1=yX5oi+w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi, hackers!
I've updated a patchset for 64-xid (actually only 0008 patch is changed).
The update addresses a corner case of not completing VACUUM FULL after
pg_upgrade from the cluster containing a maximum size tuple in plain
storage. Page with such tuples can not be converted to 64-xid format as
there is no room for HeapPageSpecial, so it remains in DoubleXmax format
and this can not be changed until that tuple version is deleted. The change
makes VACUUM FULL copy these pages instead of throwing an error.
The patchset is also rebased onto a current master branch.
Your discussion and thoughts are very much welcome!
--
Best regards,
Pavel Borisov
Postgres Professional: http://postgrespro.com <http://www.postgrespro.com>
| Attachment | Content-Type | Size |
|---|---|---|
| v37-0005-Add-initdb-option-to-initialize-cluster-with-non.patch | application/octet-stream | 24.4 KB |
| v37-0004-Use-64-bit-pages-representation-in-SLRU-callers.patch | application/octet-stream | 23.7 KB |
| v37-0007-Use-64-bit-GUCs.patch | application/octet-stream | 25.8 KB |
| v37-0006-README.XID64.patch | application/octet-stream | 7.2 KB |
| v37-0003-Use-64-bit-FullTransactionId-instead-of-Epoch-xi.patch | application/octet-stream | 18.8 KB |
| v37-0001-Use-64-bit-numbering-of-SLRU-pages.patch | application/octet-stream | 24.5 KB |
| v37-0002-Use-64-bit-format-to-output-XIDs.patch | application/octet-stream | 121.4 KB |
| v37-0008-Use-64-bit-XIDs.patch | application/octet-stream | 686.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira | 2022-06-07 14:24:55 | Re: Error from the foreign RDBMS on a foreign table I have no privilege on |
| Previous Message | Tomas Vondra | 2022-06-07 14:00:18 | Re: pgcon unconference / impact of block size on performance |