pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jonathan S. Katz <jkatz@postgresql.org>
To: Laurenz Albe <laurenz.albe@cybertec.at>
To: Bruce Momjian <bruce@momjian.us>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: First draft of PG 17 release notes
Date: Fri, 20 Sep 2024 13:47:43 -0400
Message-ID: <d1748552-31f5-4f80-937b-767b5f7d8324@postgresql.org> (raw)
In-Reply-To: <7fd6ce37f6d14678b5024767aef7f8c5a414ba0c.camel@cybertec.at>
References: <ZjxLJpnH4VMkOMmi@momjian.us>
	<0749f42a-17e1-42c9-a8d4-542fcb9fafeb@postgresql.org>
	<7fd6ce37f6d14678b5024767aef7f8c5a414ba0c.camel@cybertec.at>

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




Attachments:

v2-release-17-major-features.diff (text/plain, 2.6K) download 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>
OpenPGP_signature.asc (application/pgp-signature, 839B) download

view thread (211+ messages)  latest in thread

Message-ID: <d1748552-31f5-4f80-937b-767b5f7d8324@postgresql.org>
Permalink:  ../d1748552-31f5-4f80-937b-767b5f7d8324@postgresql.org/
Also on:    postgresql.org/message-id/d1748552-31f5-4f80-937b-767b5f7d8324@postgresql.org

 ·  · 

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: pgsql-hackers@postgresql.org
  Cc: jkatz@postgresql.org, laurenz.albe@cybertec.at, bruce@momjian.us
  Subject: Re: First draft of PG 17 release notes
  In-Reply-To: <d1748552-31f5-4f80-937b-767b5f7d8324@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox