pgsql: Set pg_class.relhassubclass for partitioned indexes

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема pgsql: Set pg_class.relhassubclass for partitioned indexes
Дата
Msg-id E1gEPd3-0007fj-6U@gemulon.postgresql.org
обсуждение исходный текст
Ответы Re: pgsql: Set pg_class.relhassubclass for partitioned indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
Set pg_class.relhassubclass for partitioned indexes

Like for relations, switching this parameter is optimistic by turning it
on each time a partitioned index gains a partition.  So seeing this
parameter set to true means that the partitioned index has or has had
partitions.  The flag cannot be reset yet for partitioned indexes, which
is something not obvious anyway as partitioned relations exist to have
partitions.

This allows to track more conveniently partition trees for indexes,
which will come in use with an upcoming patch helping in listing
partition trees with an SQL-callable function.

Author: Amit Langote
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/80306490-b5fc-ea34-4427-f29c52156052@lab.ntt.co.jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/17f206fbc824d2b4b14480199ca9ff7dea417eda

Modified Files
--------------
src/backend/catalog/index.c            |  5 ++-
src/backend/commands/indexcmds.c       |  4 +++
src/test/regress/expected/indexing.out | 56 +++++++++++++++++++++++-----------
src/test/regress/sql/indexing.sql      | 18 +++++++++--
4 files changed, 62 insertions(+), 21 deletions(-)


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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: pgsql: Fix some grammar errors in bloom.sgml
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Set pg_class.relhassubclass for partitioned indexes