agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Nathan Bossart <nathandbossart@gmail.com>
To: Jonathan S. Katz <jkatz@postgresql.org>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Michael Banck <mbanck@gmx.net>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: add list of major features to the v19 release notes
Date: Wed, 23 Sep 2026 12:48:19 -0500
Message-ID: <arQQ443FZaC7NCpL@nathan> (raw)
In-Reply-To: <41ef3063-25fe-43a4-b8d9-cd715593665f@postgresql.org>
References: <a796f7d5-1ce7-4f64-add4-bad40d7fc714@dunslane.net>
<ao2m-rfWTCtHhxCs@nathan>
<ce01d8e1-b653-4c04-91d7-54163f706795@postgresql.org>
<aqk0eJEDswnROyAm@nathan>
<aqlG-CUYpCgfhA29@momjian.us>
<aqlYgQ8vl0E2TyjZ@nathan>
<D254A4C7-5493-49DD-BF9C-CC865A838912@yesql.se>
<0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org>
<aq1eLOKSnS4Y-xDo@nathan>
<41ef3063-25fe-43a4-b8d9-cd715593665f@postgresql.org>
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
view thread (28+ messages) latest in thread
Message-ID: <arQQ443FZaC7NCpL@nathan>
Permalink: ../arQQ443FZaC7NCpL@nathan/
Also on: postgresql.org/message-id/arQQ443FZaC7NCpL@nathan
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: nathandbossart@gmail.com, jkatz@postgresql.org, daniel@yesql.se, bruce@momjian.us, andrew@dunslane.net, mbanck@gmx.net
Subject: Re: add list of major features to the v19 release notes
In-Reply-To: <arQQ443FZaC7NCpL@nathan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox