public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jonathan S. Katz <[email protected]>
To: Laurenz Albe <[email protected]>
To: Bruce Momjian <[email protected]>
To: PostgreSQL-development <[email protected]>
Subject: Re: First draft of PG 17 release notes
Date: Fri, 20 Sep 2024 13:47:43 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
On 9/20/24 12:55 PM, Laurenz Albe wrote:
> On Fri, 2024-09-20 at 10:02 -0400, Jonathan S. Katz wrote:
>> Attached is a proposal for the major features section. This borrows from
>> the release announcement draft[1] and lists out features and themes that
>> have broad user impact. This was a bit challenging for this release,
>> because there are a lot of great features in PG17 that add up to a very
>> special release.
>>
>> Feedback welcome.
>
> I would have added the platform-independent binary collation provider.
> And perhaps "pg_createsubscriber": that can be a game-changer for setting
> up logical replication.
I was on the fence about that, mostly because it'd make that sentence
too much of a mouthful, but I do agree.
IIRC (didn't get to check) we did have a precedent for sublists in the
major features, so I broke this one up. Please see attached.
Jonathan
diff --git a/doc/src/sgml/release-17.sgml b/doc/src/sgml/release-17.sgml
index 9d69016cd6..fdbbbed07a 100644
--- a/doc/src/sgml/release-17.sgml
+++ b/doc/src/sgml/release-17.sgml
@@ -18,7 +18,81 @@
</para>
<itemizedlist>
- <listitem><para>TO BE COMPLETED LATER</para></listitem>
+ <listitem>
+ <para>
+ New memory management system for <command>VACUUM</command>, which reduces
+ memory consumption and can improve overall vacuuming performance.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ New <acronym>SQL/JSON</acronym> capabilities, including constructors,
+ identity functions, and the <link
+ linkend="functions-sqljson-table"><function>JSON_TABLE()</function></link>
+ function, which converts JSON data into a table representation.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Various query performance improvements, including to sequential reads
+ using streaming I/O, write throughput under high concurrency, and
+ searches over multiple values in a <link linkend="btree">btree</link>
+ index.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Logical replication enhancements, including:
+ <itemizedlist>
+ <listitem>
+ <para>
+ Failover control
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <link
+ linkend="app-pgcreatesubscriber"><application>pg_createsubscriber</application></link>,
+ a utility that logical replicas from physical standbys
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <link
+ linkend="pgupgrade"><application>pg_upgrade</application></link> now
+ preserves replication slots on both publishers and subscribers
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ New client-side connection option, <link
+ linkend="libpq-connect-sslnegotiation"><literal>sslnegotiation=direct</literal></link>,
+ that allows direct TLS handshakes that avoids a round-trip negotation.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="app-pgbasebackup"><application>pg_basebackup</application></link>
+ now supports incremental backup.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="sql-copy"><command>COPY</command></link> adds a new option,
+ <literal>ON_ERROR ignore</literal>, that allows a copy operation to
+ continue in the event of an error.
+ </para>
+ </listitem>
</itemizedlist>
<para>
Attachments:
[text/plain] v2-release-17-major-features.diff (2.6K, ../[email protected]/2-v2-release-17-major-features.diff)
download | inline diff:
diff --git a/doc/src/sgml/release-17.sgml b/doc/src/sgml/release-17.sgml
index 9d69016cd6..fdbbbed07a 100644
--- a/doc/src/sgml/release-17.sgml
+++ b/doc/src/sgml/release-17.sgml
@@ -18,7 +18,81 @@
</para>
<itemizedlist>
- <listitem><para>TO BE COMPLETED LATER</para></listitem>
+ <listitem>
+ <para>
+ New memory management system for <command>VACUUM</command>, which reduces
+ memory consumption and can improve overall vacuuming performance.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ New <acronym>SQL/JSON</acronym> capabilities, including constructors,
+ identity functions, and the <link
+ linkend="functions-sqljson-table"><function>JSON_TABLE()</function></link>
+ function, which converts JSON data into a table representation.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Various query performance improvements, including to sequential reads
+ using streaming I/O, write throughput under high concurrency, and
+ searches over multiple values in a <link linkend="btree">btree</link>
+ index.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Logical replication enhancements, including:
+ <itemizedlist>
+ <listitem>
+ <para>
+ Failover control
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <link
+ linkend="app-pgcreatesubscriber"><application>pg_createsubscriber</application></link>,
+ a utility that logical replicas from physical standbys
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <link
+ linkend="pgupgrade"><application>pg_upgrade</application></link> now
+ preserves replication slots on both publishers and subscribers
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ New client-side connection option, <link
+ linkend="libpq-connect-sslnegotiation"><literal>sslnegotiation=direct</literal></link>,
+ that allows direct TLS handshakes that avoids a round-trip negotation.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link
+ linkend="app-pgbasebackup"><application>pg_basebackup</application></link>
+ now supports incremental backup.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <link linkend="sql-copy"><command>COPY</command></link> adds a new option,
+ <literal>ON_ERROR ignore</literal>, that allows a copy operation to
+ continue in the event of an error.
+ </para>
+ </listitem>
</itemizedlist>
<para>
[application/pgp-signature] OpenPGP_signature.asc (840B, ../[email protected]/3-OpenPGP_signature.asc)
download
view thread (146+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: First draft of PG 17 release notes
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox