Re: pg12 release notes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg12 release notes
Date
Msg-id 20190511003231.ucvhwr7i2it65gmi@momjian.us
Whole thread Raw
In response to Re: pg12 release notes  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
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
lengthof indexed values.
 
> +Btree indexes pg_upgraded from previous releases will not have this ordering.  This slightly reduces the maximum
permittedlength 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  <bruce@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 +

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Adding a test for speculative insert abort case
Next
From: Michael Paquier
Date:
Subject: Re: Bug in reindexdb's error reporting