Re: LIKE foo% optimization easily defeated by OR?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: LIKE foo% optimization easily defeated by OR?
Дата
Msg-id CAM-w4HMCCnZvrwcV+11UOEgynG4OKFJV=PcUxe5Vf4s690xxqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: LIKE foo% optimization easily defeated by OR?  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Ответы Re: LIKE foo% optimization easily defeated by OR?
Список pgsql-hackers
On 3 January 2018 at 22:34, Alexander Korotkov
<a.korotkov@postgrespro.ru> wrote:

> I've checked similar case on database with PostgreSQL mailing lists.  It
> works for me.

Wow that's fascinating. I wonder why it's not kicking in for me. I
have checked with enable_seqscan=off but I'll have to do some more
investigations. I'll try it on different instances of the database.

-- 
greg


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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: LIKE foo% optimization easily defeated by OR?
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: [HACKERS] Pluggable storage