Re: overlaps performance - Mailing list pgsql-hackers

From Grzegorz Jaśkiewicz
Subject Re: overlaps performance
Date
Msg-id 4884A6A8.90401@pointblue.com.pl
Whole thread Raw
In response to Re: overlaps performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: overlaps performance  (Gregory Stark <stark@enterprisedb.com>)
List 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.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Default of max_stack_depth and getrlimit
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: Default of max_stack_depth and getrlimit