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
Date: Thu, 7 May 2026 18:01:16 -0400
Message-ID: <af0LrP9xPkxk5Dpc@momjian.us> (raw)
In-Reply-To: <CABPTF7VxrFB_4Qoo2=PyrczGyq8CqOpQ5D5yye3DyxDC=so_0Q@mail.gmail.com>
References: <ad7ngXC125AvNqC2@momjian.us>
<CABPTF7VxrFB_4Qoo2=PyrczGyq8CqOpQ5D5yye3DyxDC=so_0Q@mail.gmail.com>
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=ae58189a4d523f0156ebe30f4534180555669...
>
>
> 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=6c228755add8f0714677440d53a160f9ed332...
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=49a181b5d634340fcfb7c762c387c03f64053...
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.
Attachments:
[text/x-diff] master.diff (1.9K, ../af0LrP9xPkxk5Dpc@momjian.us/2-master.diff)
download | inline diff:diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex 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">§</ulink>
+<ulink url="&commit_baseurl;6c228755a">§</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">§</ulink>
<ulink url="&commit_baseurl;49a181b5d">§</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">§</ulink>
+<ulink url="&commit_baseurl;ae58189a4">§</ulink>
</para>
</listitem>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: bruce@momjian.us, xunengzhou@gmail.com, pgsql-hackers@lists.postgresql.org
Subject: Re: First draft of PG 19 release notes
In-Reply-To: <af0LrP9xPkxk5Dpc@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox