Date: Mon, 26 Oct 2026 22:24:26 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Pavel Luzanov <p.luzanov@postgrespro.ru>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: First draft of PG 19 release notes
Message-ID: <auALWpk1U5NgOt0P@momjian.us>
References: <ad7ngXC125AvNqC2@momjian.us>
 <5973.1791788107@localhost>
 <as1_bGM_HKFA6HOs@momjian.us>
 <CAGRkXqSsSL=5qXYymzN+D8hPZcBZGuEcT+5zF+MXE0KL_7Kxtg@mail.gmail.com>
 <3382929.1792210380@sss.pgh.pa.us>
 <CAGRkXqRYyCZCvpnj2EA6=AJeHfPmSRssUwSsMXLsipYq+KjHnA@mail.gmail.com>
 <a838af22-7fcd-4ae7-8558-24e24be4b05f@postgrespro.ru>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="Cc3ntgNNtY6Fz4Xg"
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <a838af22-7fcd-4ae7-8558-24e24be4b05f@postgrespro.ru>
Archived-At: 
 <https://www.postgresql.org/message-id/auALWpk1U5NgOt0P%40momjian.us>
Precedence: bulk


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

On Thu, Oct 22, 2026 at 02:27:03PM +0300, Pavel Luzanov wrote:
> Hello,
> 
> The system view pg_stat_progress_repack was introduced with the REPACK
> command,
> but I can't find any reference to it in the release notes.
> Maybe it's worth adding the view to the System Views section?

I went back and forth on this one.  On the one hand, when we add a
command, if we also add a system view to monitor it, it is usually
considered part of the new command and not something we would mention.
However, the new system view does show progress for existing commands
CLUSTER and VACUUM FULL, and those are kept for compatibility vs
depricated, so it makes sense to mention this system view separately in
the release notes.

I also grouped vacuum items.  Applied patch attached.

-- 
  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.

--Cc3ntgNNtY6Fz4Xg
Content-Type: text/x-diff; charset=utf-8
Content-Disposition: attachment; filename="REL_19_STABLE.diff"
Content-Transfer-Encoding: 8bit

diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index e483d18d2e8..7d723995575 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -932,29 +932,25 @@ Add system view <link linkend="pg-stat-recovery-view"><structname>pg_stat_recove
 </listitem>
 
 <!--
-Author: Nathan Bossart <nathan@postgresql.org>
-2026-04-06 [87f61f0c8] Add pg_stat_autovacuum_scores system view.
+Author: Álvaro Herrera <alvherre@kurilemu.de>
+2026-03-10 [ac58465e0] Introduce the REPACK command
 -->
 
 <listitem>
 <para>
-Add system view <link linkend="pg-stat-autovacuum-scores-view"><structname>pg_stat_autovacuum_scores</structname></link> to report per-table <link linkend="autovacuum">autovacuum</link> details (Sami Imseih)
-<ulink url="&commit_baseurl;87f61f0c8">&sect;</ulink>
+Add system view <link linkend="pg-stat-progress-repack-view"><structname>pg_stat_progress_repack</structname></link> to report the progress of <command>REPACK</command>, <command>CLUSTER</command>, and <command>VACUUM FULL</command> (Álvaro Herrera)
 </para>
 </listitem>
 
 <!--
 Author: Nathan Bossart <nathan@postgresql.org>
-2025-07-09 [167ed8082] Introduce pg_dsm_registry_allocations view.
-Author: Nathan Bossart <nathan@postgresql.org>
-2025-12-02 [f894acb24] Show size of DSAs and dshashes in pg_dsm_registry_alloca
+2026-04-06 [87f61f0c8] Add pg_stat_autovacuum_scores system view.
 -->
 
 <listitem>
 <para>
-Add system view <link linkend="view-pg-dsm-registry-allocations"><structname>pg_dsm_registry_allocations</structname></link> to report <link linkend="guc-dynamic-shared-memory-type">dynamic shared memory</link> details (Florents Tselai, Nathan Bossart)
-<ulink url="&commit_baseurl;167ed8082">&sect;</ulink>
-<ulink url="&commit_baseurl;f894acb24">&sect;</ulink>
+Add system view <link linkend="pg-stat-autovacuum-scores-view"><structname>pg_stat_autovacuum_scores</structname></link> to report per-table <link linkend="autovacuum">autovacuum</link> details (Sami Imseih)
+<ulink url="&commit_baseurl;87f61f0c8">&sect;</ulink>
 </para>
 </listitem>
 
@@ -990,6 +986,21 @@ The new <structfield>started_by</structfield> column reports the initiator of th
 </para>
 </listitem>
 
+<!--
+Author: Nathan Bossart <nathan@postgresql.org>
+2025-07-09 [167ed8082] Introduce pg_dsm_registry_allocations view.
+Author: Nathan Bossart <nathan@postgresql.org>
+2025-12-02 [f894acb24] Show size of DSAs and dshashes in pg_dsm_registry_alloca
+-->
+
+<listitem>
+<para>
+Add system view <link linkend="view-pg-dsm-registry-allocations"><structname>pg_dsm_registry_allocations</structname></link> to report <link linkend="guc-dynamic-shared-memory-type">dynamic shared memory</link> details (Florents Tselai, Nathan Bossart)
+<ulink url="&commit_baseurl;167ed8082">&sect;</ulink>
+<ulink url="&commit_baseurl;f894acb24">&sect;</ulink>
+</para>
+</listitem>
+
 <!--
 Author: Masahiko Sawada <msawada@postgresql.org>
 2025-10-08 [d3b6183dd] Add mem_exceeded_count column to pg_stat_replication_slo

--Cc3ntgNNtY6Fz4Xg--