Re: overlaps performance

From: Grzegorz Jaśkiewicz <gj(at)pointblue(dot)com(dot)pl>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: overlaps performance
Date: 2008-07-21 14:29:09
Message-ID: 48849D35.1090100@pointblue.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregory Stark pisze:
> Grzegorz Jaśkiewicz <gj(at)pointblue(dot)com(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-07-21 14:31:04 Re: Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the
Previous Message Tatsuo Ishii 2008-07-21 14:22:59 Re: WITH RECUSIVE patches 0721