Re: PG 16 draft release notes ready
| От | Erwin Brandstetter |
|---|---|
| Тема | Re: PG 16 draft release notes ready |
| Дата | |
| Msg-id | CAGHENJ5Cj3wBH07YM5Lw2h5q8s65cNg_NEdkkWvmRo+vOormWw@mail.gmail.com обсуждение исходный текст |
| Ответ на | PG 16 draft release notes ready (Bruce Momjian <bruce@momjian.us>) |
| Ответы |
Re: PG 16 draft release notes ready
|
| Список | pgsql-hackers |
I posted to pgsql-docs first, but was kindly redirected here by Jonathan:
The release notes for Postgres 16 says here:
Same as here:
Allow window functions to use ROWS mode internally when RANGE mode is specified but unnecessary (David Rowley)
But the improvement (fix to some degree) also applies to the much more common case where no mode has been specified, RANGE unfortunately being the default.
That includes the most common use case "row_number() OVER (ORDER BY col)", where RANGE mode should not be applied to begin with, according to SQL specs. This is what made me investigate, test and eventually propose a fix in the first place. See:
Also, I was hoping to be mentioned in the release note for working this out:
Allow window functions to use the faster ROWS mode internally when RANGE mode is specified or would be default, but unnecessary (David Rowley, Erwin Brandstetter)
Thanks,
Erwin
On Sat, 19 Aug 2023 at 04:02, Bruce Momjian <bruce@momjian.us> wrote:
I have completed the first draft of the PG 16 release notes. You can
see the output here:
https://momjian.us/pgsql_docs/release-16.html
I will adjust it to the feedback I receive; that URL will quickly show
all updates.
I learned a few things creating it this time:
* I can get confused over C function names and SQL function names in
commit messages.
* The sections and ordering of the entries can greatly clarify the
items.
* The feature count is slightly higher than recent releases:
release-10: 189
release-11: 170
release-12: 180
release-13: 178
release-14: 220
release-15: 184
--> release-16: 200
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
В списке pgsql-hackers по дате отправления: