Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Burd, Greg" <greg(at)burd(dot)me>, Nikita Malakhov <hukutoc(at)gmail(dot)com>, Hannu Krosing <hannuk(at)google(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)
Date: 2025-09-16 05:14:43
Message-ID: aMjyQ-0lC1OvVzGO@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Aug 14, 2025 at 02:49:06PM +0900, Michael Paquier wrote:
> I have dropped the amcheck test patch for now, which was fun but it's
> not really necessary for the "basics". I have done also more tests,
> playing for example with pg_resetwal, installcheck and pg_upgrade
> scenarios. I am wondering if it would be worth doing a pg_resetwal in
> the node doing an installcheck on the instance to be upgraded, bumping
> its next OID to be much larger than 4 billion, actually..

Four patches had conflicts with 748caa9dcb68, so rebased as v6.
--
Michael

Attachment Content-Type Size
v6-0001-Implement-oid8-data-type.patch text/x-diff 39.2 KB
v6-0002-Refactor-some-TOAST-value-ID-code-to-use-Oid8-ins.patch text/x-diff 15.4 KB
v6-0003-Minimize-footprint-of-TOAST_MAX_CHUNK_SIZE-in-hea.patch text/x-diff 4.6 KB
v6-0004-Renames-around-varatt_external-varatt_external_oi.patch text/x-diff 20.4 KB
v6-0005-Refactor-external-TOAST-pointer-code-for-better-p.patch text/x-diff 46.2 KB
v6-0006-Move-static-inline-routines-of-varatt_external_oi.patch text/x-diff 4.7 KB
v6-0007-Split-VARATT_EXTERNAL_GET_POINTER-for-indirect-an.patch text/x-diff 5.9 KB
v6-0008-Switch-pg_column_toast_chunk_id-return-value-from.patch text/x-diff 3.6 KB
v6-0009-Add-catcache-support-for-OID8OID.patch text/x-diff 1.3 KB
v6-0010-Add-support-for-TOAST-chunk_id-type-in-binary-upg.patch text/x-diff 9.3 KB
v6-0011-Enlarge-OID-generation-to-8-bytes.patch text/x-diff 14.6 KB
v6-0012-Add-relation-option-toast_value_type.patch text/x-diff 6.5 KB
v6-0013-Add-support-for-oid8-TOAST-values.patch text/x-diff 16.9 KB
v6-0014-Add-tests-for-TOAST-relations-with-bigint-as-valu.patch text/x-diff 21.5 KB
v6-0015-Add-new-vartag_external-for-8-byte-TOAST-values.patch text/x-diff 14.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message David G. Johnston 2025-09-16 04:56:23 Re: Improving the names generated for indexes on expressions