Re: pruning disabled for array, enum, record, range type partition keys

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pruning disabled for array, enum, record, range type partition keys
Дата
Msg-id 12181.1523283752@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pruning disabled for array, enum, record, range type partition keys  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Ответы Re: pruning disabled for array, enum, record, range type partitionkeys  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список pgsql-hackers
Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> writes:
> I noticed that the newly added pruning does not work if the partition key
> is of one of the types that have a corresponding pseudo-type.

While I don't recall the details due to acute caffeine shortage,
there are specific coding patterns that are used in the planner
(e.g. in indxpath.c) to ensure that the code works with pseudotype
opclasses as well as simple ones.  The existence of this bug
indicates that those conventions were not followed in the pruning
code.  I wonder whether this patch makes the pruning code look
more like the pre-existing code, or even less like it.

            regards, tom lane


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

Предыдущее
От: Anthony Iliopoulos
Дата:
Сообщение: Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS
Следующее
От: "Shinoda, Noriyoshi"
Дата:
Сообщение: RE: WIP: Covering + unique indexes.