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 <[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 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 <[email protected]> -2026-04-06 [87f61f0c8] Add pg_stat_autovacuum_scores system view. +Author: Álvaro Herrera <[email protected]> +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">§</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 <[email protected]> -2025-07-09 [167ed8082] Introduce pg_dsm_registry_allocations view. -Author: Nathan Bossart <[email protected]> -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">§</ulink> -<ulink url="&commit_baseurl;f894acb24">§</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">§</ulink> </para> </listitem> @@ -990,6 +986,21 @@ The new <structfield>started_by</structfield> column reports the initiator of th </para> </listitem> +<!-- +Author: Nathan Bossart <[email protected]> +2025-07-09 [167ed8082] Introduce pg_dsm_registry_allocations view. +Author: Nathan Bossart <[email protected]> +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">§</ulink> +<ulink url="&commit_baseurl;f894acb24">§</ulink> +</para> +</listitem> + <!-- Author: Masahiko Sawada <[email protected]> 2025-10-08 [d3b6183dd] Add mem_exceeded_count column to pg_stat_replication_slo
