Jeff Janes wrote
> Try swapping the order of the columns in the exclude constraint. You want
> the more selective criterion to appear first in the index/constraint.
> Presumably "key with =" is the most selective, especially if many of your
> periods are unbounded.
I would not be so sure with that:
http://use-the-index-luke.com/sql/myth-directory/most-selective-first
--
View this message in context: http://postgresql.nabble.com/performance-problems-with-bulk-inserts-updates-on-tsrange-with-gist-based-exclude-constrains-tp5921498p5922219.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.