Postgres Pro
Downloads
Home   >   mailing lists

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

From John R Pierce
Subject Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
Date
Msg-id 2527a6fd-6c9b-713e-3eda-8f9250bfe906@hogranch.com
Whole thread Raw
In response to Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains  (John R Pierce <pierce@hogranch.com>)
Responses Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains  (Chris Withers <chris@simplistix.co.uk>)
Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains  (Chris Withers <chris@withers.org>)
List pgsql-general
Tree view 
On 9/16/2016 2:23 AM, John R Pierce wrote:
>
> wait, what is a tsrange?   the standard textsearch data types in
> postgres are tsvector and tsquery,

never mind,  I should have known, its a timestamp range.   ...


when you do updates, are you changing any of the indexed fields, or just
"value" ?

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
Next
From: Albe Laurenz
Date:
Subject: Re: Unable to create oracle_fdw (foreign data wrapper) extension