Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains - Mailing list pgsql-general

From Tom Lane
Subject Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
Date
Msg-id 18176.1474036192@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains  (Chris Withers <chris@simplistix.co.uk>)
Responses Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains  (Chris Withers <chris@simplistix.co.uk>)
List pgsql-general
Chris Withers <chris@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.

            regards, tom lane


pgsql-general by date:

Previous
From: Chris Withers
Date:
Subject: Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
Next
From: Chris Withers
Date:
Subject: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains