Re: overlaps performance - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: overlaps performance
Date
Msg-id 877ibf73jk.fsf@oxford.xeocode.com
Whole thread Raw
In response to overlaps performance  (Grzegorz Jaśkiewicz <gj@pointblue.com.pl>)
Responses Re: overlaps performance  (Grzegorz Jaśkiewicz <gj@pointblue.com.pl>)
Re: overlaps performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about
EnterpriseDB'sPostgreSQL training! 


pgsql-hackers by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: overlaps performance
Next
From: Tatsuo Ishii
Date:
Subject: WITH RECUSIVE patches 0721