On 16/09/2016 15:29, Tom Lane wrote:
Chris Withers <ch...@simplistix.co.uk> writes:
On 16/09/2016 14:54, Igor Neyman wrote:
So, what is the value for "end ts", when the record is inserted (the range just 
started)?


It's open ended, so the period is [start_ts, )

I've not looked at the GiST range opclass, but I would not be surprised if
having lots of those is pretty destructive to the index's ability to be
selective about && searches.

If that's so, that's a little disappointing...
(I'd have thought the special case end value (open ended) and the ending type (inclusive/exclusive) would just be sentinel values)

How would I verify your suspicions?

cheers,

Chris


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to