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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
