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 ) id 1hOuR7-0002ry-SE for pgsql-hackers@arkaria.postgresql.org; Fri, 10 May 2019 01:34:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hOuR6-0005gI-I3 for pgsql-hackers@arkaria.postgresql.org; Fri, 10 May 2019 01:34:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hOuR6-0005gB-2I for pgsql-hackers@lists.postgresql.org; Fri, 10 May 2019 01:34:56 +0000 Received: from mail-it1-x142.google.com ([2607:f8b0:4864:20::142]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hOuR3-0001fY-09 for pgsql-hackers@postgresql.org; Fri, 10 May 2019 01:34:54 +0000 Received: by mail-it1-x142.google.com with SMTP id i10so2999703ite.0 for ; Thu, 09 May 2019 18:34:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=O4krtUjzTAkEw7BqOYvxIMY+3o8IHIiWJlAGoQwrL30=; b=Wi7Zzpzu15nF9LbE/xq83QqIQPhRJHppEQNQdfiZXKm9MWRP6QoE/25W14+FAJLeaL +szAvGjqVvYs/9BRHjmYmN2gd/5KMqSxHXDebFmoXjKFxce3wpCZ1OUhqwnkthQPmhQN 7hbLBH9HALokkgs5yBQigMfA7tmnD8yJJPpit5Kc3Bf2hbns3XQoC24L49mEAFael288 8VNvBHWLSXkagi2AATZl18NgoDQcqLGTd+674/ptdTpXWlaH4mNQDrvbZOHv1wuvNY0R KFHwCQiCz8utdlFZ+OoigeCRxjKTf1EU8aBj1jEE8q7j3zlCsQmgzePMROmgencjFf7E ePLg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=O4krtUjzTAkEw7BqOYvxIMY+3o8IHIiWJlAGoQwrL30=; b=MJ1VaRqGefyswag7FxML+tO4s7zawYZo2JIFgYloes/f+H0+Yd3eBDR2kjObxBv6fu B0gnZfxeqJgOWvHWavSfLT4DONvIxe4pTanwaSeX3U04gOj2nnAvDC2z+6U7oAO1r2Gp MFJtJljPfRgj4eVYmI0uvU5bE/TeOKshuCco7tup+Py+bKN1OH4I1LKCL4OgaTHPNy/w 9sPfADxG3cdLKgJmM87MoneqMCHTCIZPXZKaAlJco9g9fH/aluXwsAmSMjEwPTXgY9hq OXgPenOXIcRqxrJdJB6SIT0kl6B9dDAUKra0wEGfQdQnRKgvQjDcJUWlbDvkFqE6CX+L EQng== X-Gm-Message-State: APjAAAVzi2aMxn7t4IqebwXgXKbxcEC2qvIpBcb6uX9baREOGjVkfeRV RQCOH6SHZN9MkieelIymX2e4WQ== X-Google-Smtp-Source: APXvYqzv/fWaVYF52slWSFWoqd2I6LwDnxXs+SR0A3OUO3+izZsCIulioSgbohXMVgXChKcWrKc2kw== X-Received: by 2002:a02:a48d:: with SMTP id d13mr5818184jam.101.1557452092256; Thu, 09 May 2019 18:34:52 -0700 (PDT) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id e84sm1687694ita.12.2019.05.09.18.34.50 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 09 May 2019 18:34:51 -0700 (PDT) Received: by pryzbyj (Postfix, from userid 1000) id B99118009A7; Thu, 9 May 2019 20:34:49 -0500 (CDT) Date: Thu, 9 May 2019 20:34:49 -0500 From: Justin Pryzby To: Bruce Momjian Cc: pgsql-hackers@postgresql.org Subject: Re: pg12 release notes Message-ID: <20190510013449.GL3925@telsasoft.com> References: <20190508203204.GA25482@telsasoft.com> <20190509233518.gqaelz5zao4jcznx@momjian.us> <20190510001335.GJ3925@telsasoft.com> <20190510010251.ppjlkn32okaokynn@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20190510010251.ppjlkn32okaokynn@momjian.us> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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: |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 .. 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 Justin