Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group