pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jonathan S. Katz <jkatz@postgresql.org>
To: Nathan Bossart <nathandbossart@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Michael Banck <mbanck@gmx.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: add list of major features to the v19 release notes
Date: Sat, 22 Aug 2026 15:56:40 -0400
Message-ID: <e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org> (raw)
In-Reply-To: <amzxHLIo5tAysXE2@nathan>
References: <akWIxtcathhoUuCQ@nathan>
	<6a46485d.2a10144b.ad66e.cd2bSMTPIN_ADDED_BROKEN@mx.google.com>
	<akZ3fkfhTe1C8iUm@nathan>
	<amjNJ53a3ls8uWCZ@nathan>
	<ampuDuA16M6ti9wi@momjian.us>
	<amzxHLIo5tAysXE2@nathan>

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


Attachments:

v2-doc-release-19-major.diff (text/plain, 4.5K) download 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>
OpenPGP_signature.asc (application/pgp-signature, 839B) download

view thread (28+ messages)  latest in thread

Message-ID: <e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org>
Permalink:  ../e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org/
Also on:    postgresql.org/message-id/e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org

 ·  · 

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: jkatz@postgresql.org, nathandbossart@gmail.com, bruce@momjian.us, mbanck@gmx.net
  Subject: Re: add list of major features to the v19 release notes
  In-Reply-To: <e2324238-abec-4026-bd44-9b3e6c70bd49@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