pgsql: Custom reloptions for table AM

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Custom reloptions for table AM
Date: 2024-04-08 08:23:44
Message-ID: E1rtkI4-00164p-40@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Custom reloptions for table AM

Let table AM define custom reloptions for its tables. This allows specifying
AM-specific parameters by the WITH clause when creating a table.

The reloptions, which could be used outside of table AM, are now extracted
into the CommonRdOptions data structure. These options could be by decision
of table AM directly specified by a user or calculated in some way.

The new test module test_tam_options evaluates the ability to set up custom
reloptions and calculate fields of CommonRdOptions on their base.

The code may use some parts from prior work by Hao Wu.

Discussion: https://postgr.es/m/CAPpHfdurb9ycV8udYqM%3Do0sPS66PJ4RCBM1g-bBpvzUfogY0EA%40mail.gmail.com
Discussion: https://postgr.es/m/AMUA1wBBBxfc3tKRLLdU64rb.1.1683276279979.Hmail.wuhao%40hashdata.cn
Reviewed-by: Reviewed-by: Pavel Borisov, Matthias van de Meent, Jess Davis

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9bd99f4c26fe37b8ee2f199aa868a0e2fdba4c43

Modified Files
--------------
src/backend/access/common/reloptions.c | 121 ++++++++++++-----
src/backend/access/heap/heapam.c | 4 +-
src/backend/access/heap/heapam_handler.c | 13 ++
src/backend/access/heap/heaptoast.c | 9 +-
src/backend/access/heap/hio.c | 4 +-
src/backend/access/heap/pruneheap.c | 4 +-
src/backend/access/heap/rewriteheap.c | 4 +-
src/backend/access/table/tableam.c | 2 +-
src/backend/access/table/tableamapi.c | 25 ++++
src/backend/commands/createas.c | 13 +-
src/backend/commands/tablecmds.c | 63 +++++----
src/backend/commands/vacuum.c | 8 +-
src/backend/postmaster/autovacuum.c | 12 +-
src/backend/tcop/utility.c | 28 +++-
src/backend/utils/cache/relcache.c | 73 +++++++++-
src/include/access/reloptions.h | 10 +-
src/include/access/tableam.h | 50 +++++++
src/include/utils/rel.h | 148 +++++++++++----------
src/test/modules/Makefile | 1 +
src/test/modules/meson.build | 1 +
src/test/modules/test_tam_options/.gitignore | 4 +
src/test/modules/test_tam_options/Makefile | 23 ++++
.../test_tam_options/expected/test_tam_options.out | 36 +++++
src/test/modules/test_tam_options/meson.build | 33 +++++
.../test_tam_options/sql/test_tam_options.sql | 25 ++++
.../test_tam_options/test_tam_options--1.0.sql | 12 ++
.../modules/test_tam_options/test_tam_options.c | 66 +++++++++
.../test_tam_options/test_tam_options.control | 4 +
src/tools/pgindent/typedefs.list | 4 +-
29 files changed, 639 insertions(+), 161 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2024-04-08 09:02:33 Re: pgsql: Custom reloptions for table AM
Previous Message Amit Kapila 2024-04-08 08:03:59 pgsql: Fix the intermittent buildfarm failures in 040_standby_failover_