On Fri, 10 May 2019 at 15:45, Tom Lane <t...@sss.pgh.pa.us> wrote: > <!-- > Author: Tom Lane <t...@sss.pgh.pa.us> > 2019-02-20 [e04a3905e] Improve planner's understanding of strictness of type > co > --> > > <para> > Allow IS NOT NULL with mis-matching types to use partial indexes more > frequently (Tom Lane) > </para> > > > If so, I think James Coleman should be the author. > > ... and yeah, James should get the credit. But there's more wrong with > the summary than that, because I don't think this was about mismatched > types particularly. The real motivation was to avoid failing to prove > the usability of WHERE-x-IS-NOT-NULL partial indexes for IN clauses with > more than 100 elements.
I think you might be mixing up two items. I'm talking about: <para> Allow IN comparisons with arrays to use <literal>IS NOT NULL</literal> partial indexes more frequently (Tom Lane) </para> to which the sgml references 65ce07e02. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
