From: Nathan Bossart <nathan@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add TOAST table to pg_index.
Date: Wed, 18 Sep 2024 19:43:55 +0000
Message-ID: <E1sr0ag-001gQf-Tr@gemulon.postgresql.org> (raw)
Add TOAST table to pg_index.
This change allows pg_index rows to use out-of-line storage for the
"indexprs" and "indpred" columns, which enables use-cases such as
very large index expressions.
This system catalog was previously not given a TOAST table due to a
fear of circularity issues (see commit 96cdeae07f). Testing has
not revealed any such problems, and it seems unlikely that the
entries for system indexes could ever need out-of-line storage. In
any case, it is still early in the v18 development cycle, so
committing this now will hopefully increase the chances of finding
any unexpected problems prior to release.
Bumps catversion.
Reported-by: Jonathan Katz
Reviewed-by: Tom Lane
Discussion: https://postgr.es/m/b611015f-b423-458c-aa2d-be0e655cc1b4%40postgresql.org
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/b52c4fc3c09ec0ec9c1f9aa676f6d74304cc2f6f
Modified Files
--------------
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_index.h | 2 ++
src/test/regress/expected/misc_sanity.out | 8 +++-----
src/test/regress/sql/misc_sanity.sql | 4 ++--
4 files changed, 8 insertions(+), 8 deletions(-)
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: nathan@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add TOAST table to pg_index.
In-Reply-To: <E1sr0ag-001gQf-Tr@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox