From: Jonathan S. Katz <jkatz@postgresql.org>
To: Daniel Gustafsson <daniel@yesql.se>
To: Nathan Bossart <nathandbossart@gmail.com>
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: Fri, 18 Sep 2026 19:23:11 +0800
Message-ID: <0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org> (raw)
In-Reply-To: <D254A4C7-5493-49DD-BF9C-CC865A838912@yesql.se>
References: <akZ3fkfhTe1C8iUm@nathan>
<amjNJ53a3ls8uWCZ@nathan>
<ampuDuA16M6ti9wi@momjian.us>
<amzxHLIo5tAysXE2@nathan>
<e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org>
<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>
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.sgmlindex 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.sgmlindex 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
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: jkatz@postgresql.org, daniel@yesql.se, nathandbossart@gmail.com, bruce@momjian.us, andrew@dunslane.net, mbanck@gmx.net
Subject: Re: add list of major features to the v19 release notes
In-Reply-To: <0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox