Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s731m-003Ipx-F6 for pgsql-hackers@arkaria.postgresql.org; Wed, 15 May 2024 01:01:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s730o-005m7a-GG for pgsql-hackers@arkaria.postgresql.org; Wed, 15 May 2024 01:00:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s730o-005m7S-6r for pgsql-hackers@lists.postgresql.org; Wed, 15 May 2024 01:00:54 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s730k-000HWs-Lu for pgsql-hackers@postgresql.org; Wed, 15 May 2024 01:00:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2024011501; h=In-Reply-To:Content-Transfer-Encoding:Content-Type: MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To: Content-ID:Content-Description; bh=QLPIQkkGkghTAVD13pucqwF+U2uQ2+TeOtcvfA5OouM=; b=HGSjbR063rgShFbdy+g9JyOyUs 354EQinvp6IB0YWsNRxSnCVxkZvPQn0UAmSTjLm1ROc9d0UVcMm86DwYOoJcz00htvzYB4BErJdMU P92FZCQRdvd3Fjhhhte2j5DZWX8SVPtCOMoK2T52SwTHGbkhrcM6ptwqufvM7amDootEOTdqRcRmq SaqcFsjj67YLVT7ZKE2Q6Q4d/SmUuBnALja9TU9QwKTO8CWKaDAT2Ga58cfnGHmsVjRDGZ9W3e/Vw YnvOchEVN0QYvUIexUNK1IAKlrc1+/E6Up0gWeuYYhKQDy5Q0DoV/xvQ4RoBQ6tJvFIvkJOtUXM8P PTnwHgHQ==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1s730k-008V5u-2E; Tue, 14 May 2024 21:00:50 -0400 Date: Tue, 14 May 2024 21:00:50 -0400 From: Bruce Momjian To: Melanie Plageman Cc: PostgreSQL-development Subject: Re: First draft of PG 17 release notes Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, May 14, 2024 at 03:39:26PM -0400, Melanie Plageman wrote: > On Thu, May 9, 2024 at 12:04 AM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsql_docs/release-17.html > > I had two comments: > > -------- > I think the read stream item: > > "Allow the grouping of file system reads with the new system variable > io_combine_limit" > > Might be better if it mentions the effect, like: > > "Reduce system calls by automatically merging reads up to io_combine_limit" Uh, as I understand it, the reduced number of system calls is not the value of the feature, but rather the ability to request a larger block from the I/O subsystem. Without it, you have to make a request and wait for each request to finish. I am open to new wording, but I am not sure your new wording is accurate. > ------- > For the vacuum feature: > > "Allow vacuum to more efficiently remove and freeze tuples" > > I think that we need to more clearly point out the implications of the > feature added by Sawada-san (and reviewed by John) in 667e65aac35497. > Vacuum no longer uses a fixed amount of memory for dead tuple TID > storage and it is not preallocated. This affects users as they may > want to change their configuration (and expectations). > > If you make that item more specific to their work, you should also > remove my name, as the work I did on vacuum this release was unrelated > to their work on dead tuple TID storage. > > The work Heikki and I did which culminated in 6dbb490261 mainly has > the impact of improving vacuum's performance (vacuum emits less WAL > and is more efficient). So you could argue for removing it from the > release notes if you are using the requirement that performance > improvements don't go in the release notes. > > However, one of the preliminary commits for this f83d70976 does change > WAL format. There are three WAL records which no longer exist as > separate records. Do users care about this? I don't think users really care about these details, just that it is faster so they will not be surprised if there is a change. I was purposely vague to group multiple commits into the single item. By grouping them together, I got enough impact to warrant listing it. If you split it apart, it is harder to justify mentioning them. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.