MIME-Version: 1.0
References: <ZjxLJpnH4VMkOMmi@momjian.us>
In-Reply-To: <ZjxLJpnH4VMkOMmi@momjian.us>
From: jian he <jian.universality@gmail.com>
Date: Fri, 17 May 2024 21:22:59 +0800
Message-ID: <CACJufxE7fbWckFeXdW86VTia2BV+LOcfNR-aPf1cP2fjxEB0Aw@mail.gmail.com>
Subject: Re: First draft of PG 17 release notes
To: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CACJufxE7fbWckFeXdW86VTia2BV%2BLOcfNR-aPf1cP2fjxEB0Aw%40mail.gmail.com>
Precedence: bulk

On Thu, May 9, 2024 at 12:04=E2=80=AFPM Bruce Momjian <bruce@momjian.us> wr=
ote:
>
> 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=3D8aee330af55d8a7=
59b2b73f5a771d9d34a7b887f

>> Add stratnum GiST support function (Paul A. Jungwirth)

>> Allow foreign keys to reference WITHOUT OVERLAPS primary keys (Paul A. J=
ungwirth)
>> 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=3D519fc1bd9e9=
d7b408903e44f55f83f6db30742b7
[2] https://www.postgresql.org/message-id/CAEZATCUJ0xjyQUL7SHKxJ5a%2BDm5pjo=
q-WO3NtkDLi6c76rh58w%40mail.gmail.com