pgsql: Custom reloptions for table AM

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема pgsql: Custom reloptions for table AM
Дата
Msg-id E1rtkI4-00164p-40@gemulon.postgresql.org
обсуждение исходный текст
Ответы Re: pgsql: Custom reloptions for table AM  (Thomas Munro <thomas.munro@gmail.com>)
Список 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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: pgsql: Fix the intermittent buildfarm failures in 040_standby_failover_
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: pgsql: Custom reloptions for table AM