On 16/09/2016 14:54, Igor Neyman wrote:
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Chris Withers
Sent: Friday, September 16, 2016 6:47 AM
To: John R Pierce <pierce@xxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
On 16/09/2016 10:26, John R Pierce wrote:
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" ?
Yeah, it's a temporal table, so "updates" involve modifying the period column for a row to set its end ts, and then inserting a new row with a start ts running on from that.
Of course, the adds are just inserting new rows.
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, )
Chris
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
