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