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 1lj0xG-0006o6-2k for pgsql-hackers@arkaria.postgresql.org; Tue, 18 May 2021 14:44:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lj0xF-0000yN-0E for pgsql-hackers@arkaria.postgresql.org; Tue, 18 May 2021 14:44:17 +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 1lj0xE-0000yE-K9 for pgsql-hackers@lists.postgresql.org; Tue, 18 May 2021 14:44:16 +0000 Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lj0xB-0007n4-L6 for pgsql-hackers@postgresql.org; Tue, 18 May 2021 14:44:16 +0000 Received: by mail-oo1-xc29.google.com with SMTP id e27-20020a056820061bb029020da48eed5cso2279279oow.10 for ; Tue, 18 May 2021 07:44:13 -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=EIZyNGpjrQde6P3hypn7vO24PkHulBKxDqppjMGhKl0=; b=lUzcCH0ZubS5dbF0dCtduz8i6nhT3BNc7QOewkIuSsSEaxZ5L64n6b0vk5fCTojQRa Lf2llnJXUaBVCt/PvX9rWlHsjWuDRkH23lzblOQzGeWupwcA2YX0nEZXZkKuV/OJX5S9 rEbroLL2oS7OxiT+z8KeQQfG+IyvWqgDosTVRJB3c3p1VnEXlCaI9xnF8mIVK0rkp7iY AoeH+1QEafom4LuonLUCS7uIGWzTc34e5qxO0b2kCsEeTtjyLho/Q+MBBIvGSmu+cBya A63pxhW5gF81LWX6Yrm7KJ2/OAUq+98J/DHmobD2vNL7q+B1c5PoXzNuUkRJzJdGI+LL Gqcg== 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=EIZyNGpjrQde6P3hypn7vO24PkHulBKxDqppjMGhKl0=; b=f/urHwqrkocwJ32oStD3FgdD1ufcdr/54aUk2ipAJKsMOYNShU8DmcqN1mYywUuLkm tfOjuoUacujxXjB2j7c43lsbMwoMzwytDr/hQXPTT8VAvTmbS9ztDqNpK00mMdbU9G4E ifAcu3MBu4B159Hdx+O1WUeXgV3uLNZdIFKS+XjLD8uTE+kIHsE5qxa0zPVPoCtNnssI 6jH7VWrtFlqdCNq+k2h5zSf4NivH5VbhyFmY1E8aQM3Bp3KJlIR1km9+H2SbiJiOEfos NHBEpv40loXd6j5XHzC/FqhFQPbTvoke5XCx05y5mv7ZYWZrUAm/wWS0joOX1zrN7+gv oHaw== X-Gm-Message-State: AOAM530faYtQ4J7Lr+ElPwPWQAJG81MHwqxb0ZKE57+erGw70acHG+GY hK3ODwH6ZqPeU/+EZWfZdj1r4Q== X-Google-Smtp-Source: ABdhPJzuMWG7+lkEJ4qiiyXwRekquwdN/oOPRtJeIrKcHn2KC1HHXCZ8eLk1nX2QMw0mfjMCTNhCkg== X-Received: by 2002:a4a:2cc5:: with SMTP id o188mr2968980ooo.15.1621349051609; Tue, 18 May 2021 07:44:11 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id z4sm1381645oib.40.2021.05.18.07.44.10 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 18 May 2021 07:44:10 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id C66AD800B20; Tue, 18 May 2021 09:44:09 -0500 (CDT) Date: Tue, 18 May 2021 09:44:09 -0500 From: Justin Pryzby To: Bruce Momjian Cc: Masahiko Sawada , pgsql-hackers@postgresql.org, Peter Geoghegan Subject: Re: PG 14 release notes, first draft Message-ID: <20210518144409.GL373@telsasoft.com> References: <20210510060308.GC6088@momjian.us> <20210518140725.GA30270@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210518140725.GA30270@momjian.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, May 18, 2021 at 10:07:25AM -0400, Bruce Momjian wrote: > On Tue, May 18, 2021 at 06:28:49PM +0900, Masahiko Sawada wrote: > > On Mon, May 10, 2021 at 3:03 PM Bruce Momjian wrote: > > > > > > I have committed the first draft of the PG 14 release notes. You can > > > see the most current build of them here: > > > > > > https://momjian.us/pgsql_docs/release-14.html > > > > I think we need to mention in the release note that > > vacuum_cleanup_index_scale_factor GUC parameter has been removed and > > vacuum_cleanup_index_scale_factor storage parameter has been > > deprecated (please refer to commit 9f3665fb and effdd3f3b63). > > Looking at the full commit message: > > commit 9f3665fbfc > Author: Peter Geoghegan > Date: Wed Mar 10 16:27:01 2021 -0800 > > Don't consider newly inserted tuples in nbtree VACUUM. > > Remove the entire idea of "stale stats" within nbtree VACUUM (stop > caring about stats involving the number of inserted tuples). Also > remove the vacuum_cleanup_index_scale_factor GUC/param on the master > branch (though just disable them on postgres 13). > This was backpatched into PG 13.3, which was released last week: > remove the stale-statistics logic. The control parameter for that, > vacuum_cleanup_index_scale_factor, will be > removed entirely in v14. In v13, it remains present to avoid > breaking existing configuration files, but it no longer does > anything. > > > > Therefore, it didn't show up in my src/tools/git_changelog output, and I > did not include it. Normally, stuff that was backpatched isn't included in major release notes, since the change would/could normally happen during a minor -> minor+1 release. As things stand, in this case I think it *should* be included, since the backpatched change isn't the same as the change to HEAD (removing the GUC). The git_changelog output might well be wrong in this case (or, arguably, the "remove the GUC entirely" should've been a separate master-only commit than the "make the GUC do nothing" commit). However, Peter indicated an intent to add a reloption to disable the vacuum optimization, so maybe the removal of the GUC could be documented at that time. -- Justin