Date: Thu, 7 May 2026 18:01:16 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Xuneng Zhou <xunengzhou@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@lists.postgresql.org>
Subject: Re: First draft of PG 19 release notes
Message-ID: <af0LrP9xPkxk5Dpc@momjian.us>
References: <ad7ngXC125AvNqC2@momjian.us>
 <CABPTF7VxrFB_4Qoo2=PyrczGyq8CqOpQ5D5yye3DyxDC=so_0Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="EFiBvMWt9ugJypDI"
Content-Disposition: inline
In-Reply-To: 
 <CABPTF7VxrFB_4Qoo2=PyrczGyq8CqOpQ5D5yye3DyxDC=so_0Q@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/af0LrP9xPkxk5Dpc%40momjian.us>
Precedence: bulk


--EFiBvMWt9ugJypDI
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Mon, Apr 20, 2026 at 09:03:41PM +0800, Xuneng Zhou wrote:
> Thanks for working on the draft. Here're some comments for it:
> 
> 1) Improve performance of pgstattuple by using streaming reads
> 
> There are two related commits that improve the performance of
> pgstattuple. The current hyperlink references [1]; would it make sense
> to include [2] too?

Sure, added.

> [1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=213f0079b
> [2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=ae58189a4d523f0156ebe30f4534180555669e88
> 
> 
> 2) Additionally, would this[3] be something worth mentioning in the
> General Performance section? The improvement looks fairly big.
> 
> [3] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=6c228755add8f0714677440d53a160f9ed332902

Sure, I added it to an existing item.

> 3) Allow standbys to wait for LSN values to be replayed via WAIT FOR
> As for this feature, the follow-up commit[4] extends the WAIT FOR
> command to support waiting for flush and write operations. Is it
> helpful for users to be aware of these use cases as well?
> 
> [4] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=49a181b5d634340fcfb7c762c387c03f6405367e

Oh, that's a good point.  I missed that additional functionality.

All fixed in the attached, applied patch.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.

--EFiBvMWt9ugJypDI
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="master.diff"

diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 6e519a8fdf7..1539f1e56d9 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -756,12 +756,15 @@ Improve performance of internal row deformation (David Rowley)
 <!--
 Author: Michael Paquier <michael@paquier.xyz>
 2026-03-16 [bfa3c4f10] Optimize hash index bulk-deletion with streaming read
+Author: Michael Paquier <michael@paquier.xyz>
+2026-03-12 [6c228755a] Use streaming read for VACUUM cleanup of GIN
 -->
 
 <listitem>
 <para>
-Improve performance of hash index bulk-deletion by using streaming reads (Xuneng Zhou)
+Improve performance of hash index bulk-deletion and GIN index vacuuming using streaming reads (Xuneng Zhou)
 <ulink url="&commit_baseurl;bfa3c4f10">&sect;</ulink>
+<ulink url="&commit_baseurl;6c228755a">&sect;</ulink>
 </para>
 </listitem>
 
@@ -1340,7 +1343,7 @@ Author: Alexander Korotkov <akorotkov@postgresql.org>
 
 <listitem>
 <para>
-Allow standbys to wait for LSN values to be replayed via WAIT FOR (Kartyshov Ivan, Alexander Korotkov, Xuneng Zhou)
+Allow standbys to wait for LSN values to be written, flushed, or replayed via WAIT FOR (Kartyshov Ivan, Alexander Korotkov, Xuneng Zhou)
 <ulink url="&commit_baseurl;447aae13b">&sect;</ulink>
 <ulink url="&commit_baseurl;49a181b5d">&sect;</ulink>
 </para>
@@ -3332,12 +3335,15 @@ Improve performance of bloom indexes by using streaming reads (Xuneng Zhou)
 <!--
 Author: Michael Paquier <michael@paquier.xyz>
 2026-03-13 [213f0079b] pgstattuple: Optimize btree and hash index functions wit
+Author: Michael Paquier <michael@paquier.xyz>
+2026-03-14 [ae58189a4] pgstattuple: Optimize pgstattuple_approx() with streamin
 -->
 
 <listitem>
 <para>
 Improve performance of pgstattuple by using streaming reads (Xuneng Zhou)
 <ulink url="&commit_baseurl;213f0079b">&sect;</ulink>
+<ulink url="&commit_baseurl;ae58189a4">&sect;</ulink>
 </para>
 </listitem>
 

--EFiBvMWt9ugJypDI--