agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: 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
Date: Thu, 2 Jul 2026 09:36:46 -0500
Message-ID: <akZ3fkfhTe1C8iUm@nathan> (raw)
In-Reply-To: <6a46485d.2a10144b.ad66e.cd2bSMTPIN_ADDED_BROKEN@mx.google.com>
References: <akWIxtcathhoUuCQ@nathan>
<6a46485d.2a10144b.ad66e.cd2bSMTPIN_ADDED_BROKEN@mx.google.com>
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 <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)
Attachments:
[text/plain] v2-0001-Add-list-of-major-features-to-the-v19-release-not.patch (3.5K, ../akZ3fkfhTe1C8iUm@nathan/2-v2-0001-Add-list-of-major-features-to-the-v19-release-not.patch)
download | inline diff:
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)
view thread (28+ messages) latest in thread
Message-ID: <akZ3fkfhTe1C8iUm@nathan>
Permalink: ../akZ3fkfhTe1C8iUm@nathan/
Also on: postgresql.org/message-id/akZ3fkfhTe1C8iUm@nathan
reply
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, mbanck@gmx.net
Subject: Re: add list of major features to the v19 release notes
In-Reply-To: <akZ3fkfhTe1C8iUm@nathan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox