Re: PG 16 draft release notes ready

I posted to pgsql-docs first, but was kindly redirected here by Jonathan:

The release notes for Postgres 16 says here:
https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PERFORMANCE

Same as here:
https://momjian.us/pgsql_docs/release-16.html#RELEASE-16-PERFORMANCE

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:

https://www.postgresql.org/message-id/flat/CAGHENJ7LBBszxS%2BSkWWFVnBmOT2oVsBhDMB1DFrgerCeYa_DyA%40mail.gmail.com
https://www.postgresql.org/message-id/flat/CAApHDvohAKEtTXxq7Pc-ic2dKT8oZfbRKeEJP64M0B6%2BS88z%2BA%40mail.gmail.com

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(at)momjian(dot)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(at)momjian(dot)us> https://momjian.us
> EDB https://enterprisedb.com
>
> Only you can decide what is important to you.
>
>
>
>
>