On Fri, May 17, 2024 at 09:22:59PM +0800, jian he wrote:
> On Thu, May 9, 2024 at 12:04 PM Bruce Momjian <br...@momjian.us> wrote:
> >
> > I have committed the first draft of the PG 17 release notes; you can
> > see the results here:
> >
> > https://momjian.us/pgsql_docs/release-17.html
> >
> > It will be improved until the final release. The item count is 188,
> > which is similar to recent releases:
> >
>
> This thread mentioned performance.
> actually this[1] refactored some interval aggregation related functions,
> which will make these two aggregate function: avg(interval), sum(interval)
> run faster, especially avg(interval).
> see [2].
> well, I guess, this is a kind of niche performance improvement to be
> mentioned separately.
>
>
> these 3 items need to be removed, because of
> https://git.postgresql.org/cgit/postgresql.git/commit/?id=8aee330af55d8a759b2b73f5a771d9d34a7b887f
>
> >> Add stratnum GiST support function (Paul A. Jungwirth)
>
> >> Allow foreign keys to reference WITHOUT OVERLAPS primary keys (Paul A.
> >> Jungwirth)
> >> The keyword PERIOD is used for this purpose.
>
> >> Allow PRIMARY KEY and UNIQUE constraints to use WITHOUT OVERLAPS for
> >> non-overlapping exclusion constraints (Paul A. Jungwirth)
>
>
> [1]
> https://git.postgresql.org/cgit/postgresql.git/commit/?id=519fc1bd9e9d7b408903e44f55f83f6db30742b7
> [2]
> https://www.postgresql.org/message-id/CAEZATCUJ0xjyQUL7SHKxJ5a%2BDm5pjoq-WO3NtkDLi6c76rh58w%40mail.gmail.com
Agreed, I have applied the attached patch to make the release notes
current.
--
Bruce Momjian <br...@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
diff --git a/doc/src/sgml/release-17.sgml b/doc/src/sgml/release-17.sgml
index 9c511848943..0bc1c9a14ad 100644
--- a/doc/src/sgml/release-17.sgml
+++ b/doc/src/sgml/release-17.sgml
@@ -6,7 +6,7 @@
<formalpara>
<title>Release date:</title>
- <para>2024-??-??, AS OF 2024-05-14</para>
+ <para>2024-??-??, AS OF 2024-05-18</para>
</formalpara>
<sect2 id="release-17-highlights">
@@ -480,17 +480,6 @@ Author: Tomas Vondra <tomas.von...@postgresql.org>
<para>
Allow BRIN indexes to be created using parallel workers (Tomas Vondra, Matthias van de Meent)
</para>
-</listitem>
-
-<!--
-Author: Peter Eisentraut <pe...@eisentraut.org>
-2024-01-19 [6db4598fc] Add stratnum GiST support function
--->
-
-<listitem>
-<para>
-Add stratnum GiST support function (Paul A. Jungwirth)
-</para>
</listitem>
</itemizedlist>
@@ -1467,34 +1456,6 @@ Add DEFAULT setting for ALTER TABLE .. SET ACCESS METHOD (Michael Paquier)
</para>
</listitem>
-<!--
-Author: Peter Eisentraut <pe...@eisentraut.org>
-2024-03-24 [34768ee36] Add temporal FOREIGN KEY contraints
--->
-
-<listitem>
-<para>
-Allow foreign keys to reference WITHOUT OVERLAPS primary keys (Paul A. Jungwirth)
-</para>
-
-<para>
-The keyword PERIOD is used for this purpose.
-</para>
-</listitem>
-
-<!--
-Author: Peter Eisentraut <pe...@eisentraut.org>
-2024-01-24 [46a0cd4ce] Add temporal PRIMARY KEY and UNIQUE constraints
-Author: Peter Eisentraut <pe...@eisentraut.org>
-2024-03-05 [030e10ff1] Rename pg_constraint.conwithoutoverlaps to conperiod
--->
-
-<listitem>
-<para>
-Allow PRIMARY KEY and UNIQUE constraints to use WITHOUT OVERLAPS for non-overlapping exclusion constraints (Paul A. Jungwirth)
-</para>
-</listitem>
-
<!--
Author: Alexander Korotkov <akorot...@postgresql.org>
2023-10-16 [e83d1b0c4] Add support event triggers on authenticated login
@@ -1957,6 +1918,8 @@ Author: Heikki Linnakangas <heikki.linnakan...@iki.fi>
2024-04-29 [17a834a04] Reject SSL connection if ALPN is used but there's no com
Author: Heikki Linnakangas <heikki.linnakan...@iki.fi>
2024-05-11 [407e0b023] Change ALPN protocol ID to IANA-approved "postgresql"
+Author: Heikki Linnakangas <heikki.linnakan...@iki.fi>
+2024-05-16 [fb5718f35] Remove option to fall back from direct to postgres SSL n
-->
<listitem>
