On 9/18/25 2:33 PM, Jonathan S. Katz wrote:
On 9/18/25 2:19 PM, Nathan Bossart wrote:
Quick analysis of the differences: Common: * AIO * skip scan * pg_upgrade * UUIDv7 * virtual generated columns * OAuth Only v1 (my patch): * OLD/NEW for RETURNING * temporal constraints * EXPLAIN enhancements Only v2 (Jonathan's): * conflict logging While the EXPLAIN enhancements and conflict logging items seem like super useful features, I can see how there might be disagreement over whetherthey belong in the major features list. I'm a little more surprised aboutthe omission of OLD/NEW and temporal contraints in v2, though. That being said, I'm tempted to suggest we UNION the two lists, bikeshed over the exact wording for a few hours, and then call it day...Let's hack on this together for a few and bring a proposal to the list.
Nathan & I hopped on a call to "pair program" on this. Given the point that his patch had been available on the list for awhile with limited public comments to date, we did the following:
* Kept everything except EXPLAIN enhancements and conflict logging. For the former, a lot of this wasn't in the default EXPLAIN path. For the latter, this was to respect the time period of the discussion.
* Did some minor wordsmithing and linking to help with overall accessibility, including Erik's typo catch.
Many thanks to Nathan for pulling this together. Please see v3. Feedback welcome.
Thanks, Jonathan
From b7e4529a99799f13ce4b701d19b2f625b548f4ac Mon Sep 17 00:00:00 2001 From: Nathan Bossart <[email protected]> Date: Thu, 18 Sep 2025 14:01:23 -0500 Subject: [PATCH v3 1/1] add major features to v18 release notes --- 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 46b4787a191..f3f44552c70 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 + 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)
OpenPGP_signature.asc
Description: OpenPGP digital signature
