postgres.git / summary / log / commit / refs

commit    b585f25284d24d2e3fe19e81583c2b458b2a3efc
Author:   Nathan Bossart <nathan@postgresql.org>
Date:     Fri Sep 19 20:07:41 2025 +0000
First released in: 18.0

    Add list of major features to the v18 release notes.
    
    Author: Nathan Bossart <nathandbossart@gmail.com>
    Co-authored-by: "Jonathan S. Katz" <jkatz@postgresql.org>
    Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
    Reviewed-by: Erik Rijkers <er@xs4all.nl>
    Reviewed-by: Robert Haas <robertmhaas@gmail.com>
    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..8811a6a1f33 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 (AIO) subsystem 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 retains optimizer statistics.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Support for "skip scan" lookups that allow using
+      <link linkend="indexes-multicolumn">multicolumn B-tree indexes</link> 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>


[parent: 142885d38053]