Date: Thu, 2 Jul 2026 09:36:46 -0500
From: Nathan Bossart <nathandbossart@gmail.com>
To: Michael Banck <mbanck@gmx.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: add list of major features to the v19 release notes
Message-ID: <akZ3fkfhTe1C8iUm@nathan>
References: <akWIxtcathhoUuCQ@nathan>
 <6a46485d.2a10144b.ad66e.cd2bSMTPIN_ADDED_BROKEN@mx.google.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="2UFzCKAzbQ/xYRnU"
Content-Disposition: inline
In-Reply-To: <6a46485d.2a10144b.ad66e.cd2bSMTPIN_ADDED_BROKEN@mx.google.com>
Archived-At: <https://www.postgresql.org/message-id/akZ3fkfhTe1C8iUm%40nathan>
Precedence: bulk


--2UFzCKAzbQ/xYRnU
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, Jul 02, 2026 at 01:15:39PM +0200, Michael Banck wrote:
> On Wed, Jul 01, 2026 at 04:38:14PM -0500, Nathan Bossart wrote:
>> +    <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>
> 
> Maybe it's because I'm not a native speaker, but I tripped over the
> second part and parsed it as a function of the replicate sequence
> values, not logical replication. Would it help readers to drop the "it",
> i.e. write "and can be enabled [...]"?

Fixed.

>> +    <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>
> 
> (This is kinda a catch-all statement and might go well as last item,
> dunno).

Moved.

>> +    <listitem>
>> +     <para>
>> +      Data checksums can now be
>> +      <link linkend="checksums-online-enable-disable">enabled or disabled while the database is running</link>.
>> +     </para>
>> +    </listitem>
> 
> I think we still don't say "the database" when we talk about a
> server/instance/cluster. It should either be "the cluster" or "the
> database server".

Fixed.

>> +    <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>
> 
> I think this sentence should include something about temporal
> ranges/keys, or maybe just s/time range/temporal range/?

How about something like this?

    Support for temporal updates and deletes via the new FOR PORTION OF
    clause.

-- 
nathan

--2UFzCKAzbQ/xYRnU
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment;
	filename=v2-0001-Add-list-of-major-features-to-the-v19-release-not.patch

From 136b53dc06490e15e0696bfdad2fbde1bf81e686 Mon Sep 17 00:00:00 2001
From: Nathan Bossart <nathan@postgresql.org>
Date: Wed, 1 Jul 2026 16:33:08 -0500
Subject: [PATCH v2 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..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--