From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: pg12 release notes
Date: Thu, 09 May 2019 23:45:01 -0400
Message-ID: <970.1557459901@sss.pgh.pa.us> (raw)
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>
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 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.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.rowley@2ndquadrant.com, bruce@momjian.us, pryzby@telsasoft.com
Subject: Re: pg12 release notes
In-Reply-To: <970.1557459901@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox