How should we treat this problem for 9.5? If we want to fix this problem completely, probably we would need to make constraint_exclusion work with even UPSERT. Which sounds difficult to do at least for 9.5. Any other idea? Or we should just treat it as a limitation of UPSERT and add that document?
+1
There are many problems that cannot be resolved for 9.5.
UPSERT works fine with tables with BRIN indexes.
--
Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services