-----Original Message----- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Withers Sent: Friday, September 16, 2016 6:47 AM To: John R Pierce <pie...@hogranch.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general