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
>From 136b53dc06490e15e0696bfdad2fbde1bf81e686 Mon Sep 17 00:00:00 2001
From: Nathan Bossart <[email protected]>
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)
