Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jWURf-0000qF-QK for pgsql-hackers@arkaria.postgresql.org; Thu, 07 May 2020 00:31:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jWURe-0001w3-Bc for pgsql-hackers@arkaria.postgresql.org; Thu, 07 May 2020 00:31:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jWURd-0001vw-VO for pgsql-hackers@lists.postgresql.org; Thu, 07 May 2020 00:31:22 +0000 Received: from mail-qk1-x733.google.com ([2607:f8b0:4864:20::733]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jWURa-0002Ij-IW for pgsql-hackers@postgresql.org; Thu, 07 May 2020 00:31:21 +0000 Received: by mail-qk1-x733.google.com with SMTP id b188so4247332qkd.9 for ; Wed, 06 May 2020 17:31:17 -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=ujo5MT1Gh1Zcj1Tpx1W73OPPsOPZhQosK6MP72psUIE=; b=yIiCtnDTCaKGImzVAS/iGU9yyLyMsMbUSXtTFE4Mt9C0UNp6HuRfrx8juAhP0vBFxC +h2fXQzrjH7MldosCucDuvzhtTqB/kMPc6ww7hwXERxxJwNGl0Owm3ZMmYgo87+wgZ9Z eOE1uYWC4uEjqGt99NZgSna90+VB/v4YlloNHmf65eqOPpnmdouKdPRCPSQE5NyeMc6o D4TWpJFzupZJq/X3DV492pxqDusJvn41KFYA4vPdWn9J5bUa1Wqv05gpyeOjGn8839wn 780j/6BqjU4/VXjXnVhnpJx/iUYBo053WhFLw883kDcMxBmQb+cUn+pBYEH5IEqo2+LU 8Fbw== 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=ujo5MT1Gh1Zcj1Tpx1W73OPPsOPZhQosK6MP72psUIE=; b=duZzApSZS/wqaJDYYs92xwVjrxZZzM/DO/kEASht9hKmEKOWLICpc/7/tNJBnKhOzI DaJtgWuY2U9pkbVkswAChwZgmbwAgDKfwHxTJcHC1XDl84L3oR0MNAEl3QZtZcF1C/kh p3LKiqNG2oG54frW4z8MY2oZ/weiqvXmqKlJlCnCftMLSWEzdBu//DbOICKDH5fKaKAz ZG+C/q/516M0peM4HPebk+2MsZvkN4CG3rVR4Zuto2SH49O2wp3NHGKZC1PH3Vugcy+L j6PYbgZP1P90WV0OblcB5RGVXbtVdR/frSZDlXo50UpokyxccgZFfmz746GkspcH+gsg CO9A== X-Gm-Message-State: AGi0PuaGeY43RKoXvpL93kGFyAA22L35tAwMVFM/kNnGlqYaxlaAMGx8 Z4Ta+l3l0Rb2H1yZgAtXkpfMpw== X-Google-Smtp-Source: APiQypJr5YPlMvBqJuAQIbHzawLcjvJ4SXGPTRBZMOiJruruJniD/35lhcHIVrYWsmzMDzZa2JmMkw== X-Received: by 2002:a37:a04a:: with SMTP id j71mr9766954qke.187.1588811476407; Wed, 06 May 2020 17:31:16 -0700 (PDT) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id h19sm2970814qtk.78.2020.05.06.17.31.15 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 06 May 2020 17:31:15 -0700 (PDT) Received: by pryzbyj (Postfix, from userid 1000) id 423A78009F4; Wed, 6 May 2020 19:31:14 -0500 (CDT) Date: Wed, 6 May 2020 19:31:14 -0500 From: Justin Pryzby To: Bruce Momjian Cc: "Andrey M. Borodin" , pgsql-hackers@postgresql.org Subject: Re: PG 13 release notes, first draft Message-ID: <20200507003114.GX28974@telsasoft.com> References: <20200505031600.GB21752@momjian.us> <20200506233534.GB3649@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200506233534.GB3649@momjian.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, May 06, 2020 at 07:35:34PM -0400, Bruce Momjian wrote: > On Wed, May 6, 2020 at 11:17:54AM +0500, Andrey M. Borodin wrote: > > I'm not sure, but probably it worth mentioning in "General performance" section that TOAST (and everything pglz-compressed) decompression should be significantly faster in v13. > > https://github.com/postgres/postgres/commit/c60e520f6e0e8db9618cad042df071a6752f3c06 > > OK, I read the thread mentioned in the commit message and I now see the > value of this change. Attached is the release note diff. Let me know > if it needs improvement. Sorry I didn't see it earlier, but: > -Improve retrieving of only the leading bytes of TOAST values (Binguo Bao) > +Improve speed of TOAST decompression and the retrievel of only the leading bytes of TOAST values (Binguo Bao, Andrey Borodin) retrieval I will include this with my running doc patch if you don't want to make a separate commit. -- Justin