Re: overlaps performance

From: Grzegorz Jaśkiewicz <gj(at)pointblue(dot)com(dot)pl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: overlaps performance
Date: 2008-07-21 15:09:28
Message-ID: 4884A6A8.90401@pointblue.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane pisze:
> The reason we don't automatically translate OVERLAPS is that the spec's
> definition of OVERLAPS is too weird for that to work; in particular
> it demands a true result for some cases in which one of the four
> endpoints is NULL, which'd be pretty hard to do with an interval-style
> index.
shame, I just work on a thing that would benefit from index that could
be used in OVERLAPS. I don't know psql internals , except for how GiST
works, hence my question.

thanks for the answer.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-07-21 15:19:40 Re: pg_dump additional options for performance
Previous Message Tom Lane 2008-07-21 15:02:37 Re: Default of max_stack_depth and getrlimit