Re: [HACKERS] Index usage for elem-contained-by-const-range clauses

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Index usage for elem-contained-by-const-range clauses
Дата
Msg-id 30347.1489784802@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Index usage for elem-contained-by-const-range clauses  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I wrote:
> * You're not bothering to insert any inputcollid into the generated
> comparison operator nodes.  I'm not sure why that fails to fall over
> for text comparisons (if indeed it does fail ...) but it's wrong.
> Use the range type's collation there.

Oh ... looking at this again, I realize that there's an additional
validity check missing: if the range type's collation doesn't match
the index column's collation, we can't do this optimization at all.
That check probably belongs in match_special_index_operator.
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] increasing the default WAL segment size
Следующее
От: Pritam Baral
Дата:
Сообщение: Re: [HACKERS] Index usage for elem-contained-by-const-range clauses