On Sat, Aug 30, 2025 at 05:56:12PM -0400, Bruce Momjian wrote: > On Sat, Aug 30, 2025 at 03:02:10PM -0500, Nathan Bossart wrote: >> The 18beta1 announcement [0] has a good list, too. *facepalm* That one >> seems to match mine pretty closely. > > Yes, the list usually comes from the press release.
Here is a first attempt at converting the press release into bullet points. -- nathan
>From d9e8dea799c68af4f1703e5daa9149497da688df Mon Sep 17 00:00:00 2001 From: Nathan Bossart <[email protected]> Date: Sat, 30 Aug 2025 22:02:10 -0500 Subject: [PATCH v1 1/1] add major features to v18 release notes --- doc/src/sgml/release-18.sgml | 66 +++++++++++++++++++++++++++++++++++- 1 file changed, 65 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 874f3113ccb..ed7131169e6 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -21,7 +21,71 @@ <listitem> <para> - (to be completed) + New asynchronous I/O subsystem that can improve performance of sequential + scans, bitmap heap scans, and vacuums. + </para> + </listitem> + + <listitem> + <para> + Support for "skip scan" lookups on + <link linkend="indexes-multicolumn">multicolumn B-tree indexes</link>. + </para> + </listitem> + + <listitem> + <para> + Various improvements to + <link linkend="pgupgrade"><application>pg_upgrade</application></link>, + such as carrying over optimizer statistics, parallelizing cluster checks, + and transferring database files by swapping directories. + </para> + </listitem> + + <listitem> + <para> + Virtual <link linkend="ddl-generated-columns">generated columns</link> + that compute their values just-in-time during query execution. + </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> + Support for UUIDv7 for generating timestamp-ordered + <link linkend="datatype-uuid">UUIDs</link>. + </para> + </listitem> + + <listitem> + <para> + Temporal constraints, or constraints over ranges, for + <link linkend="sql-createtable-parms-primary-key">PRIMARY KEY</link> and + <link linkend="sql-createtable-parms-unique">UNIQUE</link> constraints via + the <literal>WITHOUT OVERLAPS</literal> clause, and for + <link linkend="sql-createtable-parms-references">FOREIGN KEY</link> + constraints via the <literal>PERIOD</literal> clause. + </para> + </listitem> + + <listitem> + <para> + <link linkend="auth-oauth">OAuth authentication</link>. + </para> + </listitem> + + <listitem> + <para> + Additional details in <xref linkend="sql-explain"/>, including + information about buffer accesses, index lookups, CPU, and WAL. </para> </listitem> </itemizedlist> -- 2.39.5 (Apple Git-154)
