Re: overlaps performance - Mailing list pgsql-hackers

From Grzegorz Jaśkiewicz
Subject Re: overlaps performance
Date
Msg-id 48849D35.1090100@pointblue.com.pl
Whole thread Raw
In response to Re: overlaps performance  (Gregory Stark <stark@enterprisedb.com>)
List 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 by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: WITH RECUSIVE patches 0721
Next
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the