pgsql: Add TOAST table to pg_index.

From: Nathan Bossart <nathan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add TOAST table to pg_index.
Date: 2024-09-18 19:43:55
Message-ID: E1sr0ag-001gQf-Tr@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2024-09-18 20:35:18 pgsql: doc PG relnotes: no relnote footnotes for commit links in PDF
Previous Message Fujii Masao 2024-09-18 17:17:42 pgsql: docs: Improve the description of num_timed column in pg_stat_che