-----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. cheers, Chris ____________________________________________________________________________________________________ So, what is the value for "end ts", when the record is inserted (the range just started)? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
