On Thu, May 9, 2019 at 08:34:49PM -0500, Justin Pryzby wrote:
> On Thu, May 09, 2019 at 09:02:51PM -0400, Bruce Momjian wrote:
> > These were all very helpful. I adjusted your changes to create the
> > attached applied patch. URL updated:
>
> Thanks.
>
> > -Allow more comparisons with information_schema text columns to use indexes
> > (Tom Lane)
> > +Allow more use of indexes for text columns comparisons with
> > information_schema columns (Tom Lane)
>
> I think "columns" should not be plural..but it could be better still:
I now realize "columns" is not necessary, so I removed it.
> |Allow use of indexes for more comparisons with text columns of
> information_schema (Tom Lane)
>
> Regarding this proposed change of mine:
> -Btree indexes pg_upgraded from previous releases will not have this
> ordering. This slightly reduces the maximum length of indexed values.
> +Btree indexes pg_upgraded from previous releases will not have this
> ordering. This slightly reduces the maximum permitted length of indexed
> values.
>
> I think "permitted" is important, since otherwise it sounds like maybe for
> whatever values are being indexed, their maximum length is reduced by this
> patch. If you overthink it, you could decide that maybe that's happening due
> to use of prefix/suffix truncation or something ..
Agreed. I changed it to "maximum-allowed length". I also reordered the
paragraph.
> Should this one be listed twice ? I tried to tell if it was intentional but
> couldn't decide..
> 249d64999 Add support TCP user timeout in libpq and the backend se
One is a server variable, the other a libpq option.
Applied patch attached.
--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
commit b299efaea4
Author: Bruce Momjian <br...@momjian.us>
Date: Fri May 10 20:25:52 2019 -0400
doc: PG 12 release note adjustment
Reported-by: Justin Pryzby
Discussion: https://postgr.es/m/20190510013449.gl3...@telsasoft.com
diff --git a/doc/src/sgml/release-12.sgml b/doc/src/sgml/release-12.sgml
new file mode 100644
index 26e842f..91f914e
*** a/doc/src/sgml/release-12.sgml
--- b/doc/src/sgml/release-12.sgml
*************** Have new btree indexes sort duplicate in
*** 634,640 ****
</para>
<para>
! Btree indexes <application>pg_upgraded</application> from previous releases
will not have this ordering. This slightly reduces the maximum length of
indexed values.
</para>
</listitem>
--- 634,640 ----
</para>
<para>
! This slightly reduces the maximum-allowed length of indexed values. Indexes
<application>pg_upgraded</application> from previous releases will not have
this ordering.
</para>
</listitem>
*************** Author: Tom Lane <t...@sss.pgh.pa.us>
*** 1233,1239 ****
-->
<para>
! Allow more use of indexes for text columns comparisons with
<structname>information_schema</structname> columns (Tom Lane)
</para>
</listitem>
--- 1233,1239 ----
-->
<para>
! Allow more use of indexes for text comparisons with
<structname>information_schema</structname> columns (Tom Lane)
</para>
</listitem>
