Re: overlaps performance

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: overlaps performance
Дата
Msg-id 48849D35.1090100@pointblue.com.pl
обсуждение исходный текст
Ответ на Re: overlaps performance  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark pisze:
> Grzegorz Jaśkiewicz <gj@pointblue.com.pl> writes:
>
>> So my question would be, why isn't postgresql using indexes for OVERLAPS,
>> and why optimizer doesn't substitute it with something like:
>>
>> (c <= a AND d > a) OR ( c >= a AND c < b)
>
> How would you use an index for that?
>
check Depesz'es article for that. I included it at the bottom of my email.



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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: WITH RECUSIVE patches 0721
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the