From: Nathan Bossart <nathandbossart@gmail.com>
To: pgsql-hackers@postgresql.org
Subject: add list of major features to the v19 release notes
Date: Wed, 1 Jul 2026 16:38:14 -0500
Message-ID: <akWIxtcathhoUuCQ@nathan> (raw)
Here's a first try at $subject. I used the 19beta1 announcement as a
guide.
--
nathan
From 743f623a6641ae2e5d49a6f1ac8215420b720de9 Mon Sep 17 00:00:00 2001
From: Nathan Bossart <nathan@postgresql.org>
Date: Wed, 1 Jul 2026 16:33:08 -0500
Subject: [PATCH v1 1/1] Add list of major features to the v19 release notes.
---
doc/src/sgml/release-19.sgml | 79 +++++++++++++++++++++++++++++++++++-
1 file changed, 78 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex d8d3758d5ba..00c620b283c 100644--- a/doc/src/sgml/release-19.sgml+++ b/doc/src/sgml/release-19.sgml@@ -19,7 +19,84 @@
<itemizedlist>
<listitem>
- <para><emphasis>fill in later</emphasis></para>+ <para>+ Support for+ <link linkend="ddl-property-graphs">property graph queries</link>+ (<acronym>SQL/PGQ</acronym>).+ </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.+ </para>+ </listitem>++ <listitem>+ <para>+ Logical replication now+ <link linkend="logical-replication-sequences">replicates sequence values</link>,+ and it can be enabled without a server restart when+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.+ </para>+ </listitem>++ <listitem>+ <para>+ Autovacuum can now use+ <link linkend="guc-autovacuum-max-parallel-workers">multiple worker processes</link>+ to vacuum a single table in parallel, and a+ <link linkend="autovacuum-priority">new scoring system</link> prioritizes+ the tables that most need vacuuming or analyzing.+ </para>+ </listitem>++ <listitem>+ <para>+ Faster performance in many areas, including automatic scaling of the+ number of <link linkend="guc-io-max-workers">I/O worker processes</link>,+ quicker foreign-key checks, and further planning and execution+ optimizations.+ </para>+ </listitem>++ <listitem>+ <para>+ Data checksums can now be+ <link linkend="checksums-online-enable-disable">enabled or disabled while the database is running</link>.+ </para>+ </listitem>++ <listitem>+ <para>+ A new <link linkend="sql-wait-for"><command>WAIT FOR</command></link>+ command that lets an application pause until a standby has replayed+ changes up to a chosen point, thereby supporting+ <quote>read-your-writes</quote> query patterns on standbys.+ </para>+ </listitem>++ <listitem>+ <para>+ <xref linkend="sql-update"/> and <xref linkend="sql-delete"/> can now+ change or remove data for just part of a time range via the new+ <literal>FOR PORTION OF</literal> clause.+ </para>+ </listitem>++ <listitem>+ <para>+ A new+ <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>+ extension for stabilizing and controlling the query planner's decisions,+ together with the companion+ <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>+ extension that applies this advice automatically based on the query.+ </para>
</listitem>
</itemizedlist>
--
2.50.1 (Apple Git-155)
Attachments:
[text/plain] v1-0001-Add-list-of-major-features-to-the-v19-release-not.patch (3.5K, ../akWIxtcathhoUuCQ@nathan/2-v1-0001-Add-list-of-major-features-to-the-v19-release-not.patch)
download | inline diff:
From 743f623a6641ae2e5d49a6f1ac8215420b720de9 Mon Sep 17 00:00:00 2001
From: Nathan Bossart <nathan@postgresql.org>
Date: Wed, 1 Jul 2026 16:33:08 -0500
Subject: [PATCH v1 1/1] Add list of major features to the v19 release notes.
---
doc/src/sgml/release-19.sgml | 79 +++++++++++++++++++++++++++++++++++-
1 file changed, 78 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex d8d3758d5ba..00c620b283c 100644--- a/doc/src/sgml/release-19.sgml+++ b/doc/src/sgml/release-19.sgml@@ -19,7 +19,84 @@
<itemizedlist>
<listitem>
- <para><emphasis>fill in later</emphasis></para>+ <para>+ Support for+ <link linkend="ddl-property-graphs">property graph queries</link>+ (<acronym>SQL/PGQ</acronym>).+ </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.+ </para>+ </listitem>++ <listitem>+ <para>+ Logical replication now+ <link linkend="logical-replication-sequences">replicates sequence values</link>,+ and it can be enabled without a server restart when+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.+ </para>+ </listitem>++ <listitem>+ <para>+ Autovacuum can now use+ <link linkend="guc-autovacuum-max-parallel-workers">multiple worker processes</link>+ to vacuum a single table in parallel, and a+ <link linkend="autovacuum-priority">new scoring system</link> prioritizes+ the tables that most need vacuuming or analyzing.+ </para>+ </listitem>++ <listitem>+ <para>+ Faster performance in many areas, including automatic scaling of the+ number of <link linkend="guc-io-max-workers">I/O worker processes</link>,+ quicker foreign-key checks, and further planning and execution+ optimizations.+ </para>+ </listitem>++ <listitem>+ <para>+ Data checksums can now be+ <link linkend="checksums-online-enable-disable">enabled or disabled while the database is running</link>.+ </para>+ </listitem>++ <listitem>+ <para>+ A new <link linkend="sql-wait-for"><command>WAIT FOR</command></link>+ command that lets an application pause until a standby has replayed+ changes up to a chosen point, thereby supporting+ <quote>read-your-writes</quote> query patterns on standbys.+ </para>+ </listitem>++ <listitem>+ <para>+ <xref linkend="sql-update"/> and <xref linkend="sql-delete"/> can now+ change or remove data for just part of a time range via the new+ <literal>FOR PORTION OF</literal> clause.+ </para>+ </listitem>++ <listitem>+ <para>+ A new+ <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>+ extension for stabilizing and controlling the query planner's decisions,+ together with the companion+ <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>+ extension that applies this advice automatically based on the query.+ </para>
</listitem>
</itemizedlist>
--
2.50.1 (Apple Git-155)
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: nathandbossart@gmail.com
Subject: Re: add list of major features to the v19 release notes
In-Reply-To: <akWIxtcathhoUuCQ@nathan>
* 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