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 <[email protected]> https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future.
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 <[email protected]> 2026-03-16 [bfa3c4f10] Optimize hash index bulk-deletion with streaming read +Author: Michael Paquier <[email protected]> +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 <[email protected]> <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 <[email protected]> 2026-03-13 [213f0079b] pgstattuple: Optimize btree and hash index functions wit +Author: Michael Paquier <[email protected]> +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>
