agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add support for TOAST chunk_id type in binary upgrades
Date: Fri, 11 Sep 2026 01:55:40 +0000
Message-ID: <E1x4qUN-00000004N7B-3J3e@gemulon.postgresql.org> (raw)
Add support for TOAST chunk_id type in binary upgrades
This commit adds a new SQL function able to set the type of a chunk_id
attribute for a TOAST table across binary upgrades. The value is set
when the creation of a TOAST table is required across upgrades, in the
same fashion as the TOAST relation's oid and relfilenode.
Note that this piece currently works only with a TOAST table's chunk_id
set at OIDOID, because it is currently the only type of on-disk external
TOAST pointer supported. This change is required for a follow-up
feature that aims to introduce support for 8-byte OIDs in external TOAST
pointers.
Taking care of this issue separately is less code churn for the next
changes, and perhaps some of the surrounding discussions with support
for different types of external on-disk TOAST pointers will find this
new facility useful.
Bump catalog version.
Author: Michael Paquier <michael@paquier.xyz>
Reviewed-by: Greg Burd <greg@burd.me>
Reviewed-by: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Reviewed-by: Yugo Nagata <nagata@sraoss.co.jp>
Discussion: https://postgr.es/m/af19kUjwjhaoUTLn@paquier.xyz
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/34fcd735f1ebd5efba8653cdbfbfd076b081660a
Modified Files
--------------
src/backend/catalog/heap.c | 1 +
src/backend/catalog/toasting.c | 20 +++++++++++++++++++-
src/backend/utils/adt/pg_upgrade_support.c | 11 +++++++++++
src/bin/pg_dump/pg_dump.c | 14 +++++++++++---
src/include/catalog/binary_upgrade.h | 1 +
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 5 +++++
.../spgist_name_ops/expected/spgist_name_ops.out | 6 ++++--
8 files changed, 53 insertions(+), 7 deletions(-)
Message-ID: <E1x4qUN-00000004N7B-3J3e@gemulon.postgresql.org>
Permalink: ../E1x4qUN-00000004N7B-3J3e@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1x4qUN-00000004N7B-3J3e@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: michael@paquier.xyz, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add support for TOAST chunk_id type in binary upgrades
In-Reply-To: <E1x4qUN-00000004N7B-3J3e@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox