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
Date: Mon, 26 Oct 2026 22:24:26 -0400
Message-ID: <auALWpk1U5NgOt0P@momjian.us> (raw)
In-Reply-To: <a838af22-7fcd-4ae7-8558-24e24be4b05f@postgrespro.ru>
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>
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.
Attachments:REL_19_STABLE.diff (text/x-diff, 2.9K) downloaddiff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex 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">§</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">§</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 <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">§</ulink>+<ulink url="&commit_baseurl;f894acb24">§</ulink>+</para>+</listitem>+
<!--
Author: Masahiko Sawada <msawada@postgresql.org>
2025-10-08 [d3b6183dd] Add mem_exceeded_count column to pg_stat_replication_slo
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, p.luzanov@postgrespro.ru, pgsql-hackers@lists.postgresql.org
Subject: Re: First draft of PG 19 release notes
In-Reply-To: <auALWpk1U5NgOt0P@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