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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Withers <chris(at)simplistix(dot)co(dot)uk>
Cc: Igor Neyman <ineyman(at)perceptron(dot)com>, John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
Date: 2016-09-16 14:29:52
Message-ID: 18176.1474036192@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Withers <chris(at)simplistix(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Ignatov 2016-09-16 15:43:37 Re: Unable to create oracle_fdw (foreign data wrapper) extension
Previous Message Chris Withers 2016-09-16 14:26:53 Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains