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.
Ack; I took a read of the docs and saw we were referring to it as autovacuuming prioritization, so tried:+ <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.
+ <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>
OpenPGP_signature.asc
Description: OpenPGP digital signature
