Re: Lack of index usage when doing array casts

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Lack of index usage when doing array casts
Дата
Msg-id 19686.1393020721@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Lack of index usage when doing array casts  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Lack of index usage when doing array casts
Список pgsql-performance
I wrote:
> Hmm.  IIRC the text to enum cast is considered stable not immutable, which
> is why that doesn't get folded to a Const on sight.  However, it seems
> like it'd be okay for scalararraysel() to reduce stable expressions for
> estimation purposes, ie it should be using estimate_expression_value.

I've committed a patch for this; it will be in 9.3.4.

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Lack of index usage when doing array casts
Следующее
От: Alexey Klyukin
Дата:
Сообщение: Re: Lack of index usage when doing array casts