From: Jonathan S. Katz <jkatz@postgresql.org>
To: Nathan Bossart <nathandbossart@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Michael Banck <mbanck@gmx.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: add list of major features to the v19 release notes
Date: Sat, 22 Aug 2026 15:56:40 -0400
Message-ID: <e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org> (raw)
In-Reply-To: <amzxHLIo5tAysXE2@nathan>
References: <akWIxtcathhoUuCQ@nathan>
<6a46485d.2a10144b.ad66e.cd2bSMTPIN_ADDED_BROKEN@mx.google.com>
<akZ3fkfhTe1C8iUm@nathan>
<amjNJ53a3ls8uWCZ@nathan>
<ampuDuA16M6ti9wi@momjian.us>
<amzxHLIo5tAysXE2@nathan>
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.sgmlindex 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>
Attachments:
[text/plain] v2-doc-release-19-major.diff (4.5K, ../e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org/2-v2-doc-release-19-major.diff)
download | inline diff:diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex 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>
[application/pgp-signature] OpenPGP_signature.asc (839B, ../e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org/3-OpenPGP_signature.asc)
download
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: jkatz@postgresql.org, nathandbossart@gmail.com, bruce@momjian.us, mbanck@gmx.net
Subject: Re: add list of major features to the v19 release notes
In-Reply-To: <e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org>
* 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