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 <[email protected]> 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.sgml index 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)
