From: Nathan Bossart <nathan@postgresql.org>
Subject: [PATCH v2 1/1] Add list of major features to the v19 release notes.
Date: Wed, 1 Jul 2026 16:33:08 -0500
---
doc/src/sgml/release-19.sgml | 79 +++++++++++++++++++++++++++++++++++-
1 file changed, 78 insertions(+), 1 deletion(-)
inline patch 1: doc/src/sgml/release-19.sgml (+78/-1 lines) download inline-1.patchdiff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex d8d3758d5ba..7065a0be549 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 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>+ Data checksums can now be+ <link linkend="checksums-online-enable-disable">enabled or disabled while the database server 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>+ Support for temporal updates and deletes via the new+ <link linkend="dml-application-time-update-delete"><literal>FOR PORTION OF</literal></link>+ 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>++ <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>
</itemizedlist>
--
2.50.1 (Apple Git-155)
--2UFzCKAzbQ/xYRnU--
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: nathan@postgresql.org
Subject: Re: [PATCH v2 1/1] Add list of major features to the v19 release notes.
In-Reply-To: <no-message-id-653288@localhost>
* 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