Re: PG 18 relnotes and RC1

[Jonathan S. Katz]

On 9/17/25 2:51 PM, Jonathan S. Katz wrote:

On Sep 17, 2025, at 2:47 PM, Peter Eisentraut <pe...@eisentraut.org> wrote:

On 31.08.25 05:02, Nathan Bossart wrote:

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.

This seems fine.  I suggest you commit this, so we get it done.

I had messaged Bruce saying I was going to draft today, latest tomorrow. Please 
hold off.

Please see attached draft for the major features of PostgreSQL 18.

Thanks,

Jonathan

diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml
index 63ce3473dc5..62fd3779dff 100644
--- a/doc/src/sgml/release-18.sgml
+++ b/doc/src/sgml/release-18.sgml
@@ -21,7 +21,55 @@
 
     <listitem>
      <para>
-      (to be completed)
+      An asynchronous I/O subsystem (AIO) that can improves throughput
+      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>
+      <link linkend="hot-standby-conflict">Conflict</link> logging during
+     logical replication.
      </para>
     </listitem>
    </itemizedlist>

OpenPGP_signature.asc
Description: OpenPGP digital signature