On Fri, Mar 2, 2018 at 11:12 AM, Alexander Kuzmenkov <a.kuzmen...@postgrespro.ru> wrote: > On 16.01.2018 10:49, Jeff Davis wrote: >> My proposed fix is to make an internal opfamily identical to the >> external one, such that it's not recognized as part of the same EC, >> and the planner won't try to eliminate it. It loses out on potential >> optimizations, but those are mostly theoretical since the btree >> opclass ordering for ranges is not very interesting to a user. > > I think I figured out what to do with missing sort directions. We can change > select_outer_pathkeys_for_merge() to generate the pathkeys we need. Also, > find_mergeclauses_for_outer_pathkeys() has to be changed too, so that it > knows which pathkeys are compatible to which range join clauses. > > About the patch, do I understand it right that you are working on the next > version now?
I think we are quite clearly past the deadline to submit a new patch for inclusion in v11 at this point. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company