agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feed[PATCH v2 1/1] Add list of major features to the v19 release notes.
28+ messages / 8 participants
[nested] [flat]
* [PATCH v2 1/1] Add list of major features to the v19 release notes.
@ 2026-07-01 21:33 Nathan Bossart <nathan@postgresql.org>
0 siblings, 0 replies; 28+ messages in thread
From: Nathan Bossart @ 2026-07-01 21:33 UTC (permalink / raw)
---
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--
^ permalink raw reply [nested|flat] 28+ messages in thread
* [PATCH v1 1/1] Add list of major features to the v19 release notes.
@ 2026-07-01 21:33 Nathan Bossart <nathan@postgresql.org>
0 siblings, 0 replies; 28+ messages in thread
From: Nathan Bossart @ 2026-07-01 21:33 UTC (permalink / raw)
---
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)
--Dy4bd/k8yrlB0eLC--
^ permalink raw reply [nested|flat] 28+ messages in thread
* [PATCH v2 1/1] Add list of major features to the v19 release notes.
@ 2026-07-01 21:33 Nathan Bossart <nathan@postgresql.org>
0 siblings, 0 replies; 28+ messages in thread
From: Nathan Bossart @ 2026-07-01 21:33 UTC (permalink / raw)
---
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--
^ permalink raw reply [nested|flat] 28+ messages in thread
* add list of major features to the v19 release notes
@ 2026-07-01 21:38 Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 2 replies; 28+ messages in thread
From: Nathan Bossart @ 2026-07-01 21:38 UTC (permalink / raw)
To: pgsql-hackers
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 <nathan@postgresql.org>
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)
Attachments:
[text/plain] v1-0001-Add-list-of-major-features-to-the-v19-release-not.patch (3.5K, ../../akWIxtcathhoUuCQ@nathan/2-v1-0001-Add-list-of-major-features-to-the-v19-release-not.patch)
download | inline diff:
From 743f623a6641ae2e5d49a6f1ac8215420b720de9 Mon Sep 17 00:00:00 2001
From: Nathan Bossart <nathan@postgresql.org>
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)
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-07-02 11:15 Michael Banck <mbanck@gmx.net>
parent: Nathan Bossart <nathandbossart@gmail.com>
1 sibling, 0 replies; 28+ messages in thread
From: Michael Banck @ 2026-07-02 11:15 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; +Cc: pgsql-hackers
Hi,
yay for having this in place earlier this time.
Some comments:
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 [...]"?
> + <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).
> + <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".
> + <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/?
Michael
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-07-02 14:36 Nathan Bossart <nathandbossart@gmail.com>
parent: Nathan Bossart <nathandbossart@gmail.com>
1 sibling, 1 reply; 28+ messages in thread
From: Nathan Bossart @ 2026-07-02 14:36 UTC (permalink / raw)
To: Michael Banck <mbanck@gmx.net>; +Cc: pgsql-hackers
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)
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-07-28 15:39 Nathan Bossart <nathandbossart@gmail.com>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 28+ messages in thread
From: Nathan Bossart @ 2026-07-28 15:39 UTC (permalink / raw)
To: Michael Banck <mbanck@gmx.net>; +Cc: pgsql-hackers
On Thu, Jul 02, 2026 at 09:36:46AM -0500, Nathan Bossart wrote:
> Subject: [PATCH v2 1/1] Add list of major features to the v19 release notes.
Barring more feedback, I'd like to proceed with this patch sooner than
later.
--
nathan
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-07-29 21:18 Bruce Momjian <bruce@momjian.us>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 28+ messages in thread
From: Bruce Momjian @ 2026-07-29 21:18 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; +Cc: Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Tue, Jul 28, 2026 at 10:39:19AM -0500, Nathan Bossart wrote:
> On Thu, Jul 02, 2026 at 09:36:46AM -0500, Nathan Bossart wrote:
> > Subject: [PATCH v2 1/1] Add list of major features to the v19 release notes.
>
> Barring more feedback, I'd like to proceed with this patch sooner than
> later.
Sure, I am usually not involved with the major feature list.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-07-31 19:01 Nathan Bossart <nathandbossart@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 28+ messages in thread
From: Nathan Bossart @ 2026-07-31 19:01 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Michael Banck <mbanck@gmx.net>; pgsql-hackers
Committed.
--
nathan
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-08-22 19:56 Jonathan S. Katz <jkatz@postgresql.org>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 28+ messages in thread
From: Jonathan S. Katz @ 2026-08-22 19:56 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; Bruce Momjian <bruce@momjian.us>; +Cc: Michael Banck <mbanck@gmx.net>; pgsql-hackers
On 7/31/26 3:01 PM, Nathan Bossart wrote:
> Committed.
Thanks for drafting this!
I think there's a notable omission, specifically around the `ALTER TABLE
... MERGE/SPLIT PARTITIONS` as this has historically been a challenging
operation for folks. I added proposed copy here (which is mostly a
rewording of the release note).
This has been up for awhile, so I don't want to suggest removing items
for this list. That said, I'd like to suggest a few
listing/wording/ordering tweaks, primarily to tighten up a few of the
explanations and align with the style from previous release notes.
Thanks,
Jonathan
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index a8046ab41f0..bb5815a8a4d 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -22,52 +22,54 @@
<para>
Support for
<link linkend="ddl-property-graphs">property graph queries</link>
- (<acronym>SQL/PGQ</acronym>).
+ using the <acronym>SQL/PGQ</acronym> standard.
</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.
+ New <link linkend="sql-repack"><command>REPACK</command></link> command
+ that reclaims disk space and reorganizes table contents, which can help
+ increase query performance. <literal>REPACK CONCURRENTLY</literal>
+ 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>.
+ <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>
+ extension for controlling query planner decisions and
+ <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
+ extension that applies plan advice automatically based on the query.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Logical replication and can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</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>.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait-for"><command>WAIT FOR</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Introduce <link linkend="sql-altertable"><command>ALTER TABLE ... MERGE/SPLIT PARTITIONS</command></link>
+ to allow merging and splitting of partitions.
</para>
</listitem>
@@ -81,20 +83,22 @@
<listitem>
<para>
- A new
- <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>
- extension for stabilizing and controlling the query planner's decisions,
- and a companion
- <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Support <quote>read-your-writes</quote> on standbys with the new
+ <link linkend="sql-wait-for"><command>WAIT FOR</command></link> command.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="checksums-online-enable-disable">Online enablement of data checksums</link>.
</para>
</listitem>
</itemizedlist>
Attachments:
[text/plain] v2-doc-release-19-major.diff (4.5K, ../../e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org/2-v2-doc-release-19-major.diff)
download | inline diff:
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index a8046ab41f0..bb5815a8a4d 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -22,52 +22,54 @@
<para>
Support for
<link linkend="ddl-property-graphs">property graph queries</link>
- (<acronym>SQL/PGQ</acronym>).
+ using the <acronym>SQL/PGQ</acronym> standard.
</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.
+ New <link linkend="sql-repack"><command>REPACK</command></link> command
+ that reclaims disk space and reorganizes table contents, which can help
+ increase query performance. <literal>REPACK CONCURRENTLY</literal>
+ 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>.
+ <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>
+ extension for controlling query planner decisions and
+ <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
+ extension that applies plan advice automatically based on the query.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Logical replication and can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</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>.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait-for"><command>WAIT FOR</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Introduce <link linkend="sql-altertable"><command>ALTER TABLE ... MERGE/SPLIT PARTITIONS</command></link>
+ to allow merging and splitting of partitions.
</para>
</listitem>
@@ -81,20 +83,22 @@
<listitem>
<para>
- A new
- <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>
- extension for stabilizing and controlling the query planner's decisions,
- and a companion
- <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Support <quote>read-your-writes</quote> on standbys with the new
+ <link linkend="sql-wait-for"><command>WAIT FOR</command></link> command.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="checksums-online-enable-disable">Online enablement of data checksums</link>.
</para>
</listitem>
</itemizedlist>
[application/pgp-signature] OpenPGP_signature.asc (839B, ../../e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org/3-OpenPGP_signature.asc)
download
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-08-22 21:50 Andrew Dunstan <andrew@dunslane.net>
parent: Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 1 reply; 28+ messages in thread
From: Andrew Dunstan @ 2026-08-22 21:50 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; Nathan Bossart <nathandbossart@gmail.com>; Bruce Momjian <bruce@momjian.us>; +Cc: Michael Banck <mbanck@gmx.net>; pgsql-hackers
On 2026-08-22 Sa 3:56 PM, Jonathan S. Katz wrote:
> On 7/31/26 3:01 PM, Nathan Bossart wrote:
>> Committed.
> Thanks for drafting this!
>
> I think there's a notable omission, specifically around the `ALTER
> TABLE ... MERGE/SPLIT PARTITIONS` as this has historically been a
> challenging operation for folks. I added proposed copy here (which is
> mostly a rewording of the release note).
>
> This has been up for awhile, so I don't want to suggest removing items
> for this list. That said, I'd like to suggest a few
> listing/wording/ordering tweaks, primarily to tighten up a few of the
> explanations and align with the style from previous release notes.
>
>
I don't know how the ordering was arrived at. I think we should lead
with blockbuster items. Everyone will have their own opinion, but in my
mind the blockbuster items are REPACK and pg_plan_advice.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-08-25 14:30 Nathan Bossart <nathandbossart@gmail.com>
parent: Andrew Dunstan <andrew@dunslane.net>
0 siblings, 1 reply; 28+ messages in thread
From: Nathan Bossart @ 2026-08-25 14:30 UTC (permalink / raw)
To: Andrew Dunstan <andrew@dunslane.net>; +Cc: Jonathan S. Katz <jkatz@postgresql.org>; Bruce Momjian <bruce@momjian.us>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Sat, Aug 22, 2026 at 05:50:56PM -0400, Andrew Dunstan wrote:
> On 2026-08-22 Sa 3:56 PM, Jonathan S. Katz wrote:
>> This has been up for awhile, so I don't want to suggest removing items
>> for this list. That said, I'd like to suggest a few
>> listing/wording/ordering tweaks, primarily to tighten up a few of the
>> explanations and align with the style from previous release notes.
>
> I don't know how the ordering was arrived at. I think we should lead with
> blockbuster items. Everyone will have their own opinion, but in my mind the
> blockbuster items are REPACK and pg_plan_advice.
There wasn't a whole lot of science around the ordering. We did
intentionally put the catch-all performance item at the end, but that was
about the extent of conscious thought about it.
Jonathan's proposed changes seem fine to me at a glance. I'll let that
marinate on the lists a bit more before applying.
--
nathan
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-08-25 15:52 Jonathan S. Katz <jkatz@postgresql.org>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 28+ messages in thread
From: Jonathan S. Katz @ 2026-08-25 15:52 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; Andrew Dunstan <andrew@dunslane.net>; +Cc: Bruce Momjian <bruce@momjian.us>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On 8/25/26 10:30 AM, Nathan Bossart wrote:
> On Sat, Aug 22, 2026 at 05:50:56PM -0400, Andrew Dunstan wrote:
>> On 2026-08-22 Sa 3:56 PM, Jonathan S. Katz wrote:
>>> This has been up for awhile, so I don't want to suggest removing items
>>> for this list. That said, I'd like to suggest a few
>>> listing/wording/ordering tweaks, primarily to tighten up a few of the
>>> explanations and align with the style from previous release notes.
>>
>> I don't know how the ordering was arrived at. I think we should lead with
>> blockbuster items. Everyone will have their own opinion, but in my mind the
>> blockbuster items are REPACK and pg_plan_advice.
"Blockbuster" means different things to different people - when I
propose ordering, I'm typically looking for an optimization around how
many users does the change impact and how resounding that impact is.
That said, in the proposed patch I did shuffle the order around that
algorithm - if needed I'm happy to detail the thinking more, but I like
to be careful around this given people have put a lot of work and effort
into all the patches and did work specifically because they want to make
things better/easier for users.
> There wasn't a whole lot of science around the ordering. We did
> intentionally put the catch-all performance item at the end, but that was
> about the extent of conscious thought about it.
>
> Jonathan's proposed changes seem fine to me at a glance. I'll let that
> marinate on the lists a bit more before applying.
Thanks; happy to make additional tweaks if need be.
Thanks,
Jonathan
Attachments:
[application/pgp-signature] OpenPGP_signature.asc (839B, ../../ce01d8e1-b653-4c04-91d7-54163f706795@postgresql.org/2-OpenPGP_signature.asc)
download
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-15 12:05 Nathan Bossart <nathandbossart@gmail.com>
parent: Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 1 reply; 28+ messages in thread
From: Nathan Bossart @ 2026-09-15 12:05 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Andrew Dunstan <andrew@dunslane.net>; Bruce Momjian <bruce@momjian.us>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Tue, Aug 25, 2026 at 09:52:32AM -0600, Jonathan S. Katz wrote:
> On 8/25/26 10:30 AM, Nathan Bossart wrote:
>> Jonathan's proposed changes seem fine to me at a glance. I'll let that
>> marinate on the lists a bit more before applying.
>
> Thanks; happy to make additional tweaks if need be.
A number of things have been (or are being) reverted, so this will need to
be reworked. We might want to bump one or two features into the list while
we're at it.
--
nathan
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-15 13:24 Bruce Momjian <bruce@momjian.us>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 28+ messages in thread
From: Bruce Momjian @ 2026-09-15 13:24 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; +Cc: Jonathan S. Katz <jkatz@postgresql.org>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Tue, Sep 15, 2026 at 07:05:12AM -0500, Nathan Bossart wrote:
> On Tue, Aug 25, 2026 at 09:52:32AM -0600, Jonathan S. Katz wrote:
> > On 8/25/26 10:30 AM, Nathan Bossart wrote:
> >> Jonathan's proposed changes seem fine to me at a glance. I'll let that
> >> marinate on the lists a bit more before applying.
> >
> > Thanks; happy to make additional tweaks if need be.
>
> A number of things have been (or are being) reverted, so this will need to
> be reworked. We might want to bump one or two features into the list while
> we're at it.
FYI, I have not modified that list since I am not the owner of that part
of the doc. However, I didn't see anything that needs removal so I
assume others have updated it.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-15 14:38 Nathan Bossart <nathandbossart@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 28+ messages in thread
From: Nathan Bossart @ 2026-09-15 14:38 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Jonathan S. Katz <jkatz@postgresql.org>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Tue, Sep 15, 2026 at 09:24:08AM -0400, Bruce Momjian wrote:
> On Tue, Sep 15, 2026 at 07:05:12AM -0500, Nathan Bossart wrote:
>> On Tue, Aug 25, 2026 at 09:52:32AM -0600, Jonathan S. Katz wrote:
>> > On 8/25/26 10:30 AM, Nathan Bossart wrote:
>> >> Jonathan's proposed changes seem fine to me at a glance. I'll let that
>> >> marinate on the lists a bit more before applying.
>> >
>> > Thanks; happy to make additional tweaks if need be.
>>
>> A number of things have been (or are being) reverted, so this will need to
>> be reworked. We might want to bump one or two features into the list while
>> we're at it.
>
> FYI, I have not modified that list since I am not the owner of that part
> of the doc. However, I didn't see anything that needs removal so I
> assume others have updated it.
I think the only remaining item that is pending removal is the online
checksums one, and I'm willing to bet that Daniel will take care of that.
What needs rework is Jonathan's patch.
--
nathan
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-16 21:31 Daniel Gustafsson <daniel@yesql.se>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 28+ messages in thread
From: Daniel Gustafsson @ 2026-09-16 21:31 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; +Cc: Bruce Momjian <bruce@momjian.us>; Jonathan S. Katz <jkatz@postgresql.org>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
> On 15 Sep 2026, at 16:38, Nathan Bossart <nathandbossart@gmail.com> wrote:
> I think the only remaining item that is pending removal is the online
> checksums one, and I'm willing to bet that Daniel will take care of that.
I did.
--
Daniel Gustafsson
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-18 11:23 Jonathan S. Katz <jkatz@postgresql.org>
parent: Daniel Gustafsson <daniel@yesql.se>
0 siblings, 1 reply; 28+ messages in thread
From: Jonathan S. Katz @ 2026-09-18 11:23 UTC (permalink / raw)
To: Daniel Gustafsson <daniel@yesql.se>; Nathan Bossart <nathandbossart@gmail.com>; +Cc: Bruce Momjian <bruce@momjian.us>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On 9/16/26 5:31 PM, Daniel Gustafsson wrote:
>> On 15 Sep 2026, at 16:38, Nathan Bossart <nathandbossart@gmail.com> wrote:
>
>> I think the only remaining item that is pending removal is the online
>> checksums one, and I'm willing to bet that Daniel will take care of that.
>
> I did.
Here's v3 of the major features list. This merges in the changes from
the v2 proposal upthread with the other changes to the list over the
past several weeks.
Thanks,
Jonathan
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 0266d6a98e0..86f74df125c 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -6,7 +6,7 @@
<formalpara>
<title>Release date:</title>
- <para>2026-??-??, AS OF 2026-09-14</para>
+ <para>2026-??-??, AS OF 2026-09-18</para>
</formalpara>
<sect2 id="release-19-highlights">
@@ -20,58 +20,56 @@
<itemizedlist>
<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.
+ New <link linkend="sql-repack"><command>REPACK</command></link> command
+ that reclaims disk space and reorganizes table contents, which can help
+ increase query performance. <literal>REPACK CONCURRENTLY</literal>
+ 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>.
+ <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>
+ extension for controlling query planner decisions and
+ <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
+ extension that applies plan advice automatically based on the query.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait"><command>WAIT</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Logical replication and can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</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,
- and a companion
- <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ Support <quote>read-your-writes</quote> on standbys with the new
+ <link linkend="sql-wait"><command>WAIT FOR</command></link> command.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.
</para>
</listitem>
</itemizedlist>
Attachments:
[text/plain] v3-doc-release-19-major.diff (4.0K, ../../0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org/2-v3-doc-release-19-major.diff)
download | inline diff:
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 0266d6a98e0..86f74df125c 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -6,7 +6,7 @@
<formalpara>
<title>Release date:</title>
- <para>2026-??-??, AS OF 2026-09-14</para>
+ <para>2026-??-??, AS OF 2026-09-18</para>
</formalpara>
<sect2 id="release-19-highlights">
@@ -20,58 +20,56 @@
<itemizedlist>
<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.
+ New <link linkend="sql-repack"><command>REPACK</command></link> command
+ that reclaims disk space and reorganizes table contents, which can help
+ increase query performance. <literal>REPACK CONCURRENTLY</literal>
+ 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>.
+ <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>
+ extension for controlling query planner decisions and
+ <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
+ extension that applies plan advice automatically based on the query.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait"><command>WAIT</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Logical replication and can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</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,
- and a companion
- <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ Support <quote>read-your-writes</quote> on standbys with the new
+ <link linkend="sql-wait"><command>WAIT FOR</command></link> command.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.
</para>
</listitem>
</itemizedlist>
[application/pgp-signature] OpenPGP_signature.asc (839B, ../../0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org/3-OpenPGP_signature.asc)
download
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-18 15:52 Nathan Bossart <nathandbossart@gmail.com>
parent: Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 1 reply; 28+ messages in thread
From: Nathan Bossart @ 2026-09-18 15:52 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Daniel Gustafsson <daniel@yesql.se>; Bruce Momjian <bruce@momjian.us>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Fri, Sep 18, 2026 at 07:23:11PM +0800, Jonathan S. Katz wrote:
> Here's v3 of the major features list. This merges in the changes from the v2
> proposal upthread with the other changes to the list over the past several
> weeks.
Thanks for the patch.
> + New <link linkend="sql-repack"><command>REPACK</command></link> command
nit: extra space before "command"
> + that reclaims disk space and reorganizes table contents, which can help
> + increase query performance. <literal>REPACK CONCURRENTLY</literal>
> + allows repacking without blocking reads and writes to the table.
s/which can help increase/which can improve
> + Logical replication and can now be enabled without a server restart when
> + <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
nit: extra "and"
> + Support <quote>read-your-writes</quote> on standbys with the new
Hm. Can we be more descriptive here? Maybe something like "Support for
read-your-writes query patterns on standbys via the new..."
> + <link linkend="sql-wait"><command>WAIT FOR</command></link> command.
Per commits 1a562a2661b and e527bf17d04, I think we're just calling it
"WAIT" and not "WAIT FOR".
> + <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.
IMHO this makes it sound like users will be able to choose the priority of
each individual table, when we actually are just giving them a handful of
coarse controls. I think we ought to emphasize the scoring system instead.
In theory, most users shouldn't need to adjust anything and the
prioritization will "Just Work" for them.
--
nathan
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-23 14:51 Jonathan S. Katz <jkatz@postgresql.org>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 3 replies; 28+ messages in thread
From: Jonathan S. Katz @ 2026-09-23 14:51 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; +Cc: Daniel Gustafsson <daniel@yesql.se>; Bruce Momjian <bruce@momjian.us>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On 9/18/26 11:52 AM, Nathan Bossart wrote:
> Thanks for the patch.
Thanks for the review - sorry for the delay, for some reason this didn't
hit my inbox.
> nit: extra space before "command"
Fixed.
> s/which can help increase/which can improve
Accepted.
> nit: extra "and"
Fixed.
> Hm. Can we be more descriptive here? Maybe something like "Support for
> read-your-writes query patterns on standbys via the new..."
Doing some research, it seems the most common word is "consistency". I
opted for that. LMK what you think.
> Per commits 1a562a2661b and e527bf17d04, I think we're just calling it
> "WAIT" and not "WAIT FOR".
Ack; I'll refrain from bikeshedding. Adjusted.
>> + <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.
>
> IMHO this makes it sound like users will be able to choose the priority of
> each individual table, when we actually are just giving them a handful of
> coarse controls. I think we ought to emphasize the scoring system instead.
> In theory, most users shouldn't need to adjust anything and the
> prioritization will "Just Work" for them.
Ack; I took a read of the docs and saw we were referring to it as
autovacuuming prioritization, so tried:
+ <link linkend="autovacuum-priority">autovacuuming prioritization</link>
+ through a new scoring system.
if you think that makes sense based on that. Patch attached.
Thanks,
Jonathan
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 0266d6a98e0..82063b87c0b 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -6,7 +6,7 @@
<formalpara>
<title>Release date:</title>
- <para>2026-??-??, AS OF 2026-09-14</para>
+ <para>2026-??-??, AS OF 2026-09-18</para>
</formalpara>
<sect2 id="release-19-highlights">
@@ -20,58 +20,58 @@
<itemizedlist>
<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.
+ New <link linkend="sql-repack"><command>REPACK</command></link> command
+ that reclaims disk space and reorganizes table contents, which can improve
+ query performance. <literal>REPACK CONCURRENTLY</literal> 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>.
+ <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>
+ extension for controlling query planner decisions and
+ <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
+ extension that applies plan advice automatically based on the query.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait"><command>WAIT</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Logical replication can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</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,
- and a companion
- <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ Support <quote>read-your-writes</quote> consistency on standbys with the
+ new
+ <link linkend="sql-wait"><command>WAIT</command></link> command.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">autovacuuming prioritization</link>
+ through a new scoring system.
</para>
</listitem>
</itemizedlist>
Attachments:
[text/plain] v4-doc-release-19-major.diff (4.0K, ../../41ef3063-25fe-43a4-b8d9-cd715593665f@postgresql.org/2-v4-doc-release-19-major.diff)
download | inline diff:
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 0266d6a98e0..82063b87c0b 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -6,7 +6,7 @@
<formalpara>
<title>Release date:</title>
- <para>2026-??-??, AS OF 2026-09-14</para>
+ <para>2026-??-??, AS OF 2026-09-18</para>
</formalpara>
<sect2 id="release-19-highlights">
@@ -20,58 +20,58 @@
<itemizedlist>
<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.
+ New <link linkend="sql-repack"><command>REPACK</command></link> command
+ that reclaims disk space and reorganizes table contents, which can improve
+ query performance. <literal>REPACK CONCURRENTLY</literal> 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>.
+ <link linkend="pgplanadvice"><application>pg_plan_advice</application></link>
+ extension for controlling query planner decisions and
+ <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
+ extension that applies plan advice automatically based on the query.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait"><command>WAIT</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Logical replication can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</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,
- and a companion
- <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ Support <quote>read-your-writes</quote> consistency on standbys with the
+ new
+ <link linkend="sql-wait"><command>WAIT</command></link> command.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">autovacuuming prioritization</link>
+ through a new scoring system.
</para>
</listitem>
</itemizedlist>
[application/pgp-signature] OpenPGP_signature.asc (839B, ../../41ef3063-25fe-43a4-b8d9-cd715593665f@postgresql.org/3-OpenPGP_signature.asc)
download
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-23 15:20 Florents Tselai <florents.tselai@gmail.com>
parent: Jonathan S. Katz <jkatz@postgresql.org>
2 siblings, 1 reply; 28+ messages in thread
From: Florents Tselai @ 2026-09-23 15:20 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Nathan Bossart <nathandbossart@gmail.com>; Daniel Gustafsson <daniel@yesql.se>; Bruce Momjian <bruce@momjian.us>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
> On 23 Sep 2026, at 5:51 PM, Jonathan S. Katz <jkatz@postgresql.org> wrote:
>
> On 9/18/26 11:52 AM, Nathan Bossart wrote:
>
>> Thanks for the patch.
>
> Thanks for the review - sorry for the delay, for some reason this didn't hit my inbox.
>
>> nit: extra space before "command"
>
> Fixed.
>
>> s/which can help increase/which can improve
>
> Accepted.
>
>> nit: extra "and"
>
> Fixed.
>
>> Hm. Can we be more descriptive here? Maybe something like "Support for
>> read-your-writes query patterns on standbys via the new..."
>
> Doing some research, it seems the most common word is "consistency". I opted for that. LMK what you think.
>
>> Per commits 1a562a2661b and e527bf17d04, I think we're just calling it
>> "WAIT" and not "WAIT FOR".
>
> Ack; I'll refrain from bikeshedding. Adjusted.
>
>>> + <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.
>> IMHO this makes it sound like users will be able to choose the priority of
>> each individual table, when we actually are just giving them a handful of
>> coarse controls. I think we ought to emphasize the scoring system instead.
>> In theory, most users shouldn't need to adjust anything and the
>> prioritization will "Just Work" for them.
> Ack; I took a read of the docs and saw we were referring to it as autovacuuming prioritization, so tried:
>
> + <link linkend="autovacuum-priority">autovacuuming prioritization</link>
> + through a new scoring system.
>
> if you think that makes sense based on that. Patch attached.
>
> Thanks,
>
> Jonathan
>
> <v4-doc-release-19-major.diff>
Hi,
Would it be worth mentioning the new jsonpath string methods in the release highlights? (My patch —> biased)
The overview currently focuses mostly on operational and performance improvements, and this could provide a useful application-developer-facing addition.
Its value is in how the methods compose: trimming whitespace, normalizing case, replacing text, and extracting string components directly within JSON path expressions.
This makes common JSON querying and data-cleaning tasks easier to express without moving those operations into surrounding SQL.
Also note that 18 itself was thin on JSON improvements it
Possible wording: “Expanded SQL/JSON path support with string methods for text normalization and extraction, enabling more expressive JSON queries.”
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-23 17:48 Nathan Bossart <nathandbossart@gmail.com>
parent: Jonathan S. Katz <jkatz@postgresql.org>
2 siblings, 1 reply; 28+ messages in thread
From: Nathan Bossart @ 2026-09-23 17:48 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Daniel Gustafsson <daniel@yesql.se>; Bruce Momjian <bruce@momjian.us>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Wed, Sep 23, 2026 at 10:51:31AM -0400, Jonathan S. Katz wrote:
> On 9/18/26 11:52 AM, Nathan Bossart wrote:
>> Thanks for the patch.
>
> Thanks for the review - sorry for the delay, for some reason this didn't hit
> my inbox.
No worries. Here's what I have after a little more copy-editing. I don't
think we should update the "AS OF" line; I think that's something Bruce
uses for the parts he manages.
--
nathan
From 851be0cae73ddc696ae06149e37eb0b77f1a0e3f Mon Sep 17 00:00:00 2001
From: Nathan Bossart <nathan@postgresql.org>
Date: Wed, 23 Sep 2026 12:47:25 -0500
Subject: [PATCH v5 1/1] update list of major features for v19
---
doc/src/sgml/release-19.sgml | 52 +++++++++++++++++-------------------
1 file changed, 25 insertions(+), 27 deletions(-)
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 0266d6a98e0..9f81f319595 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -20,58 +20,56 @@
<itemizedlist>
<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.
+ New <xref linkend="sql-repack"/> command that reclaims disk space and
+ reorganizes table contents, which can improve query performance.
+ <command>REPACK (CONCURRENTLY)</command> 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>.
+ <xref linkend="pgplanadvice"/> extension for controlling query planner
+ decisions and <xref linkend="pgstashadvice"/> extension that applies plan
+ advice automatically based on the query.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait"><command>WAIT</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Logical replication can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</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,
- and a companion
- <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ Support for <quote>read-your-writes</quote> consistency on standbys via
+ the new <xref linkend="sql-wait"/> command.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">autovacuum prioritization</link>
+ through a new scoring system.
</para>
</listitem>
</itemizedlist>
--
2.55.0
Attachments:
[text/plain] v5-0001-update-list-of-major-features-for-v19.patch (4.0K, ../../arQQ443FZaC7NCpL@nathan/2-v5-0001-update-list-of-major-features-for-v19.patch)
download | inline diff:
From 851be0cae73ddc696ae06149e37eb0b77f1a0e3f Mon Sep 17 00:00:00 2001
From: Nathan Bossart <nathan@postgresql.org>
Date: Wed, 23 Sep 2026 12:47:25 -0500
Subject: [PATCH v5 1/1] update list of major features for v19
---
doc/src/sgml/release-19.sgml | 52 +++++++++++++++++-------------------
1 file changed, 25 insertions(+), 27 deletions(-)
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 0266d6a98e0..9f81f319595 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -20,58 +20,56 @@
<itemizedlist>
<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.
+ New <xref linkend="sql-repack"/> command that reclaims disk space and
+ reorganizes table contents, which can improve query performance.
+ <command>REPACK (CONCURRENTLY)</command> 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>.
+ <xref linkend="pgplanadvice"/> extension for controlling query planner
+ decisions and <xref linkend="pgstashadvice"/> extension that applies plan
+ advice automatically based on the query.
</para>
</listitem>
<listitem>
<para>
- Autovacuum can now use
- <link linkend="guc-autovacuum-max-parallel-workers">parallel worker processes</link>
- to vacuum a table's indexes, and a
- <link linkend="autovacuum-priority">new scoring system</link> prioritizes
- the tables that most need vacuuming or analyzing.
+ Better performance in many areas, including automatic scaling of the
+ number of I/O worker processes, quicker foreign-key checks, and further
+ planning and execution optimizations.
</para>
</listitem>
<listitem>
<para>
- A new <link linkend="sql-wait"><command>WAIT</command></link>
- command that waits until a standby has replayed changes up to a chosen
- point, thereby supporting <quote>read-your-writes</quote> query patterns
- on standbys.
+ Logical replication can now be enabled without a server restart when
+ <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
</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,
- and a companion
- <link linkend="pgstashadvice"><application>pg_stash_advice</application></link>
- extension that applies this advice automatically based on the query.
+ Logical replication of
+ <link linkend="logical-replication-sequences">sequence values</link>.
</para>
</listitem>
<listitem>
<para>
- Better performance in many areas, including automatic scaling of the
- number of I/O worker processes, quicker foreign-key checks, and further
- planning and execution optimizations.
+ Support for <quote>read-your-writes</quote> consistency on standbys via
+ the new <xref linkend="sql-wait"/> command.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="guc-autovacuum-max-parallel-workers">Parallel autovacuum of table indexes</link>
+ and
+ <link linkend="autovacuum-priority">autovacuum prioritization</link>
+ through a new scoring system.
</para>
</listitem>
</itemizedlist>
--
2.55.0
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-23 17:53 Jonathan S. Katz <jkatz@postgresql.org>
parent: Nathan Bossart <nathandbossart@gmail.com>
0 siblings, 1 reply; 28+ messages in thread
From: Jonathan S. Katz @ 2026-09-23 17:53 UTC (permalink / raw)
To: Nathan Bossart <nathandbossart@gmail.com>; +Cc: Daniel Gustafsson <daniel@yesql.se>; Bruce Momjian <bruce@momjian.us>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On 9/23/26 1:48 PM, Nathan Bossart wrote:
> On Wed, Sep 23, 2026 at 10:51:31AM -0400, Jonathan S. Katz wrote:
>> On 9/18/26 11:52 AM, Nathan Bossart wrote:
>>> Thanks for the patch.
>>
>> Thanks for the review - sorry for the delay, for some reason this didn't hit
>> my inbox.
(fortunately this hit the inbox :)
> No worries. Here's what I have after a little more copy-editing.
LGTM - thanks!
> I don't
> think we should update the "AS OF" line; I think that's something Bruce
> uses for the parts he manages.
Ack.
Thanks!
Jonathan
Attachments:
[application/pgp-signature] OpenPGP_signature.asc (839B, ../../e18fa50c-da87-4826-8e24-6f445bd23010@postgresql.org/2-OpenPGP_signature.asc)
download
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-23 18:12 Jonathan S. Katz <jkatz@postgresql.org>
parent: Florents Tselai <florents.tselai@gmail.com>
0 siblings, 0 replies; 28+ messages in thread
From: Jonathan S. Katz @ 2026-09-23 18:12 UTC (permalink / raw)
To: Florents Tselai <florents.tselai@gmail.com>; +Cc: Nathan Bossart <nathandbossart@gmail.com>; Daniel Gustafsson <daniel@yesql.se>; Bruce Momjian <bruce@momjian.us>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On 9/23/26 11:20 AM, Florents Tselai wrote:
> Would it be worth mentioning the new jsonpath string methods in the release highlights? (My patch —> biased)
>
> The overview currently focuses mostly on operational and performance improvements, and this could provide a useful application-developer-facing addition.
Thanks for the suggestion. I'm covering this in the
soon-to-be-published-for-review press release, alongside some of the
other developer experience improvements.
Thanks,
Jonathan
Attachments:
[application/pgp-signature] OpenPGP_signature.asc (839B, ../../96a3c390-5dc0-4256-8f60-6794a0310c84@postgresql.org/2-OpenPGP_signature.asc)
download
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-23 19:10 Nathan Bossart <nathandbossart@gmail.com>
parent: Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 0 replies; 28+ messages in thread
From: Nathan Bossart @ 2026-09-23 19:10 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Daniel Gustafsson <daniel@yesql.se>; Bruce Momjian <bruce@momjian.us>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Wed, Sep 23, 2026 at 01:53:13PM -0400, Jonathan S. Katz wrote:
> LGTM - thanks!
Committed.
--
nathan
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-24 15:24 Bruce Momjian <bruce@momjian.us>
parent: Jonathan S. Katz <jkatz@postgresql.org>
2 siblings, 1 reply; 28+ messages in thread
From: Bruce Momjian @ 2026-09-24 15:24 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Nathan Bossart <nathandbossart@gmail.com>; Daniel Gustafsson <daniel@yesql.se>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Wed, Sep 23, 2026 at 10:51:31AM -0400, Jonathan Katz wrote:
> On 9/18/26 11:52 AM, Nathan Bossart wrote:
>
> > Thanks for the patch.
>
> Thanks for the review - sorry for the delay, for some reason this didn't hit
> my inbox.
> diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
> index 0266d6a98e0..82063b87c0b 100644
> --- a/doc/src/sgml/release-19.sgml
> +++ b/doc/src/sgml/release-19.sgml
> @@ -6,7 +6,7 @@
>
> <formalpara>
> <title>Release date:</title>
> - <para>2026-??-??, AS OF 2026-09-14</para>
> + <para>2026-??-??, AS OF 2026-09-18</para>
> </formalpara>
Uh, did you verify there were no major-release-note relevant changes
before changing the date above? I ask because I use this date with
git_changelog to find all relevant changes. There probably are not, but
I want to verify.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-24 15:26 Jonathan S. Katz <jkatz@postgresql.org>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 28+ messages in thread
From: Jonathan S. Katz @ 2026-09-24 15:26 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Nathan Bossart <nathandbossart@gmail.com>; Daniel Gustafsson <daniel@yesql.se>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On 9/24/26 11:24 AM, Bruce Momjian wrote:
> On Wed, Sep 23, 2026 at 10:51:31AM -0400, Jonathan Katz wrote:
>> <formalpara>
>> <title>Release date:</title>
>> - <para>2026-??-??, AS OF 2026-09-14</para>
>> + <para>2026-??-??, AS OF 2026-09-18</para>
>> </formalpara>
>
> Uh, did you verify there were no major-release-note relevant changes
> before changing the date above? I ask because I use this date with
> git_changelog to find all relevant changes. There probably are not, but
> I want to verify.
Nathan removed the date change in [1].
Thanks,
Jonathan
[1] https://www.postgresql.org/message-id/arQQ443FZaC7NCpL%40nathan
Attachments:
[application/pgp-signature] OpenPGP_signature.asc (839B, ../../6e42bb11-3b85-44ab-b98a-85ab96f8016e@postgresql.org/2-OpenPGP_signature.asc)
download
^ permalink raw reply [nested|flat] 28+ messages in thread
* Re: add list of major features to the v19 release notes
@ 2026-09-25 02:35 Bruce Momjian <bruce@momjian.us>
parent: Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 0 replies; 28+ messages in thread
From: Bruce Momjian @ 2026-09-25 02:35 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Nathan Bossart <nathandbossart@gmail.com>; Daniel Gustafsson <daniel@yesql.se>; Andrew Dunstan <andrew@dunslane.net>; Michael Banck <mbanck@gmx.net>; pgsql-hackers
On Thu, Sep 24, 2026 at 11:26:54AM -0400, Jonathan Katz wrote:
> On 9/24/26 11:24 AM, Bruce Momjian wrote:
> > On Wed, Sep 23, 2026 at 10:51:31AM -0400, Jonathan Katz wrote:
>
> > > <formalpara>
> > > <title>Release date:</title>
> > > - <para>2026-??-??, AS OF 2026-09-14</para>
> > > + <para>2026-??-??, AS OF 2026-09-18</para>
> > > </formalpara>
> >
> > Uh, did you verify there were no major-release-note relevant changes
> > before changing the date above? I ask because I use this date with
> > git_changelog to find all relevant changes. There probably are not, but
> > I want to verify.
> Nathan removed the date change in [1].
Great, thanks.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
^ permalink raw reply [nested|flat] 28+ messages in thread
end of thread, other threads:[~2026-09-25 02:35 UTC | newest]
Thread overview: 28+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-07-01 21:33 [PATCH v2 1/1] Add list of major features to the v19 release notes. Nathan Bossart <nathan@postgresql.org>
2026-07-01 21:33 [PATCH v2 1/1] Add list of major features to the v19 release notes. Nathan Bossart <nathan@postgresql.org>
2026-07-01 21:33 [PATCH v1 1/1] Add list of major features to the v19 release notes. Nathan Bossart <nathan@postgresql.org>
2026-07-01 21:38 add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-07-02 11:15 ` Re: add list of major features to the v19 release notes Michael Banck <mbanck@gmx.net>
2026-07-02 14:36 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-07-28 15:39 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-07-29 21:18 ` Re: add list of major features to the v19 release notes Bruce Momjian <bruce@momjian.us>
2026-07-31 19:01 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-08-22 19:56 ` Re: add list of major features to the v19 release notes Jonathan S. Katz <jkatz@postgresql.org>
2026-08-22 21:50 ` Re: add list of major features to the v19 release notes Andrew Dunstan <andrew@dunslane.net>
2026-08-25 14:30 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-08-25 15:52 ` Re: add list of major features to the v19 release notes Jonathan S. Katz <jkatz@postgresql.org>
2026-09-15 12:05 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-09-15 13:24 ` Re: add list of major features to the v19 release notes Bruce Momjian <bruce@momjian.us>
2026-09-15 14:38 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-09-16 21:31 ` Re: add list of major features to the v19 release notes Daniel Gustafsson <daniel@yesql.se>
2026-09-18 11:23 ` Re: add list of major features to the v19 release notes Jonathan S. Katz <jkatz@postgresql.org>
2026-09-18 15:52 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-09-23 14:51 ` Re: add list of major features to the v19 release notes Jonathan S. Katz <jkatz@postgresql.org>
2026-09-23 15:20 ` Re: add list of major features to the v19 release notes Florents Tselai <florents.tselai@gmail.com>
2026-09-23 18:12 ` Re: add list of major features to the v19 release notes Jonathan S. Katz <jkatz@postgresql.org>
2026-09-23 17:48 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-09-23 17:53 ` Re: add list of major features to the v19 release notes Jonathan S. Katz <jkatz@postgresql.org>
2026-09-23 19:10 ` Re: add list of major features to the v19 release notes Nathan Bossart <nathandbossart@gmail.com>
2026-09-24 15:24 ` Re: add list of major features to the v19 release notes Bruce Momjian <bruce@momjian.us>
2026-09-24 15:26 ` Re: add list of major features to the v19 release notes Jonathan S. Katz <jkatz@postgresql.org>
2026-09-25 02:35 ` Re: add list of major features to the v19 release notes Bruce Momjian <bruce@momjian.us>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox