On Fri, Sep 19, 2025 at 09:25:52AM -0500, Nathan Bossart wrote: > I'm hoping to commit this around 20:00 UTC today, and I will be happy to > address any feedback that folks have in the meantime.
Here's a v4. The content is the same except for a typo fix, some formatting adjustments that don't change anything in the generated page, and a real commit message. I'm okay with the content, but I figured I'd note some thoughts: + An asynchronous I/O subsystem (AIO) that can improve performance of + sequential scans, bitmap heap scans, vacuums, and other operations. I wondered whether we should put "(AIO)" before "subsystem", but I think putting it next to "I/O" makes the line too busy. Also, are there "other operations", or is the rest of the list complete? + <link linkend="pgupgrade"><application>pg_upgrade</application></link> + now maintains optimizer statistics through upgrade. I think "retain" might be a better verb than "maintain", but the meaning seems clear either way. Also, while we could probably omit "through upgrade", the small amount of redundancy does (IMHO) reinforce the meaning a bit. + Support for "skip scan" lookups that allow + <link linkend="indexes-multicolumn">multicolumn B-tree indexes</link> to + be used in more cases. Passive voice. Perhaps this should be "that allow using ... in more cases." + <link linkend="sql-createtable-parms-generated-stored">generated columns</link> + that compute their values during read operations. This is now the + default for generated columns. I liked the phrase "just-in-time" for this because it expresses how it works. Perhaps we should squeeze that in before "during read operations". -- nathan
>From c90f76ba2eb31c25955f06d3bf0314e6e01a141a Mon Sep 17 00:00:00 2001 From: Nathan Bossart <[email protected]> Date: Fri, 19 Sep 2025 11:23:46 -0500 Subject: [PATCH v4 1/1] Add list of major features to the v18 release notes. Author: Nathan Bossart <[email protected]> Co-authored-by: "Jonathan S. Katz" <[email protected]> Reviewed-by: Peter Eisentraut <[email protected]> Reviewed-by: Erik Rijkers <[email protected]> Reviewed-by: Robert Haas <[email protected]> Discussion: https://postgr.es/m/aLMo7lJKg8bWUs3y%40momjian.us Backpatch-through: 18 only --- doc/src/sgml/release-18.sgml | 60 +++++++++++++++++++++++++++++++++++- 1 file changed, 59 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 8f13786fe88..6a9fe419acf 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -21,7 +21,65 @@ <listitem> <para> - (to be completed) + An asynchronous I/O subsystem (AIO) that can improve performance of + sequential scans, bitmap heap scans, vacuums, and other operations. + </para> + </listitem> + + <listitem> + <para> + <link linkend="pgupgrade"><application>pg_upgrade</application></link> + now maintains optimizer statistics through upgrade. + </para> + </listitem> + + <listitem> + <para> + Support for "skip scan" lookups that allow + <link linkend="indexes-multicolumn">multicolumn B-tree indexes</link> to + be used in more cases. + </para> + </listitem> + + <listitem> + <para> + <link linkend="func_uuid_gen_table"><function>uuidv7()</function></link> + function for generating timestamp-ordered + <link linkend="datatype-uuid">UUIDs</link>. + </para> + </listitem> + + <listitem> + <para> + Virtual + <link linkend="sql-createtable-parms-generated-stored">generated columns</link> + that compute their values during read operations. This is now the + default for generated columns. + </para> + </listitem> + + <listitem> + <para> + <link linkend="auth-oauth">OAuth authentication</link> support. + </para> + </listitem> + + <listitem> + <para> + <literal>OLD</literal> and <literal>NEW</literal> support for + <link linkend="dml-returning"><literal>RETURNING</literal></link> clauses + in <xref linkend="sql-insert"/>, <xref linkend="sql-update"/>, + <xref linkend="sql-delete"/>, and <xref linkend="sql-merge"/> commands. + </para> + </listitem> + + <listitem> + <para> + Temporal constraints, or constraints over ranges, for + <link linkend="sql-createtable-parms-primary-key">PRIMARY KEY</link>, + <link linkend="sql-createtable-parms-unique">UNIQUE</link>, and + <link linkend="sql-createtable-parms-references">FOREIGN KEY</link> + constraints. </para> </listitem> </itemizedlist> -- 2.39.5 (Apple Git-154)
