Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1hOwTA-0000un-W0
	for pgsql-hackers@arkaria.postgresql.org; Fri, 10 May 2019 03:45:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1hOwT9-0003SZ-H5
	for pgsql-hackers@arkaria.postgresql.org; Fri, 10 May 2019 03:45:11 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1hOwT9-0003SN-8G
	for pgsql-hackers@lists.postgresql.org; Fri, 10 May 2019 03:45:11 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1hOwT3-0003Fw-2S
	for pgsql-hackers@postgresql.org; Fri, 10 May 2019 03:45:10 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x4A3j1aA000971;
	Thu, 9 May 2019 23:45:01 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <david.rowley@2ndquadrant.com>
cc: Bruce Momjian <bruce@momjian.us>, Justin Pryzby <pryzby@telsasoft.com>,
        PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: pg12 release notes
In-reply-to: 
 <CAKJS1f-NDmeA_tb0oRFhrgf19xq3A9MeoyMcckY04Ct=_i0c2A@mail.gmail.com>
References: <20190508203204.GA25482@telsasoft.com>
 <20190509233518.gqaelz5zao4jcznx@momjian.us>
 <20190510001335.GJ3925@telsasoft.com>
 <20190510010251.ppjlkn32okaokynn@momjian.us>
 <CAKJS1f-NDmeA_tb0oRFhrgf19xq3A9MeoyMcckY04Ct=_i0c2A@mail.gmail.com>
Comments: In-reply-to David Rowley <david.rowley@2ndquadrant.com>
	message dated "Fri, 10 May 2019 15:34:15 +1200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <969.1557459901.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 09 May 2019 23:45:01 -0400
Message-ID: <970.1557459901@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

David Rowley <david.rowley@2ndquadrant.com> writes:
> Just a question about the item: "Allow IN comparisons with arrays to
> use IS NOT NULL partial indexes more frequently (Tom Lane)"

> From what I can tell this must refer to 65ce07e0202f.

You can tell for sure by looking into the SGML comments in
release-12.sgml:

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2019-02-20 [e04a3905e] Improve planner's understanding of strictness of ty=
pe co
-->

<para>
Allow IS NOT NULL with mis-matching types to use partial indexes more freq=
uently (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.

			regards, tom lane