On 7/31/26 3:01 PM, Nathan Bossart wrote:
Committed.
Thanks for drafting this!
I think there's a notable omission, specifically around the `ALTER TABLE ... MERGE/SPLIT PARTITIONS` as this has historically been a challenging operation for folks. I added proposed copy here (which is mostly a rewording of the release note).
This has been up for awhile, so I don't want to suggest removing items for this list. That said, I'd like to suggest a few listing/wording/ordering tweaks, primarily to tighten up a few of the explanations and align with the style from previous release notes.
Thanks, Jonathan
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index a8046ab41f0..bb5815a8a4d 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -22,52 +22,54 @@
<para>
Support for
<link linkend="ddl-property-graphs">property graph queries</link>
- (<acronym>SQL/PGQ</acronym>).
+ using the <acronym>SQL/PGQ</acronym> standard.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-repack"><command>REPACK</command></link> command
- that reclaims disk space and reorganizes table contents, combining the
- functionality of the existing <command>VACUUM FULL</command> and
- <command>CLUSTER</command> commands. Its <literal>CONCURRENTLY</literal>
- option allows repacking without blocking reads and writes to the table.
+ New <link linkend="sql-repack"><command>REPACK</command></link> command
+ that reclaims disk space and reorganizes table contents, which can help
+ increase query performance. <literal>REPACK CONCURRENTLY</literal>
+ allows repacking without blocking reads and writes to the table.
</para>
</listitem>
<listitem>
<para>
- Logical replication now
- <link linkend="logical-replication-sequences">replicates sequence
values</link>
- and can be enabled without a server restart when
- <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
+ <link
linkend="pgplanadvice"><application>pg_plan_advice</application></link>
+ extension for controlling query planner decisions and
+ <link
linkend="pgstashadvice"><application>pg_stash_advice</application></link>
+ extension that applies plan advice automatically based on the query.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker
processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Logical replication and can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</para>
</listitem>
<listitem>
<para>
- Data checksums can now be
- <link linkend="checksums-online-enable-disable">enabled or disabled
while the database server is running</link>.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait-for"><command>WAIT FOR</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Introduce <link linkend="sql-altertable"><command>ALTER TABLE ...
MERGE/SPLIT PARTITIONS</command></link>
+ to allow merging and splitting of partitions.
</para>
</listitem>
@@ -81,20 +83,22 @@
<listitem>
<para>
- A new
- <link
linkend="pgplanadvice"><application>pg_plan_advice</application></link>
- extension for stabilizing and controlling the query planner's decisions,
- and a companion
- <link
linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Support <quote>read-your-writes</quote> on standbys with the new
+ <link linkend="sql-wait-for"><command>WAIT FOR</command></link> command.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum
of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">user-defined prioritization of
autovacuuming</link>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="checksums-online-enable-disable">Online enablement of
data checksums</link>.
</para>
</listitem>
</itemizedlist>
OpenPGP_signature.asc
Description: OpenPGP digital signature
