Re: PG 16 draft release notes ready

David Rowley <dgrowleyml@gmail.com>

From: David Rowley <dgrowleyml@gmail.com>

To: Bruce Momjian <bruce@momjian.us>

Cc: Andres Freund <andres@anarazel.de>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2023-05-23T20:48:56Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Revert MAINTAIN privilege and pg_maintain predefined role.
- 151c22deee66 17.0 cited
doc: PG 16 relnotes, remove "Have initdb use ICU by default"
- c729642bd760 16.0 cited
initdb: change default --locale-provider back to libc.
- 2535c74b1a61 16.0 cited
doc: PG 16 relnotes, add author
- b9e3f8005c99 16.0 landed
doc: PG 16 relnotes, move memory item and reword OUTER item
- e6a254c0d4af 16.0 landed
doc: PG 16 relnotes, add memory overhead reduction item
- 409d24485cbe 16.0 landed
doc: PG 16 relnotes, adjust subscription origin mention
- f7c16a120cfa 16.0 landed
doc: PG 16 relnotes, adjust auto_explain logging item
- 0bcb3ca3b95b 16.0 landed
doc: PG 16 relnotes: adjust outer/full hash join parallelization
- 5a6464096622 16.0 landed
doc: PG 16 relnotes, fix duplicate author and commit
- 9e28b83ae6fa 16.0 landed
doc: PG 16 relnotes, fix "locale" typo and windows locale text
- 503b0556d96f 16.0 landed
doc: PG 16 relnotes, add author from previous merge
- 46ba86cd32dc 16.0 landed
doc: PG 16 relnotes, wording adjustments
- 5c2c59ba0b5f 16.0 landed
doc: PG 16 relnotes, merge and move vector items
- ad5406246bff 16.0 landed
doc: PG 16 relnotes, update xid/subxid searches item
- a817edbf6f30 16.0 landed
doc: PG 16 relnotes, SIMD improvements
- 5cb54fc310fb 16.0 landed
doc: PG 16 relnotes, add major features list
- 60751aa50313 16.0 landed
doc: PG 16 relnotes, misc merged items and bootstrap detail
- de7c3fd34e0f 16.0 landed
doc: PG 16 relnotes, misc. updates
- c822358a256c 16.0 landed
doc: PG 16 relnotes, add commits
- 30579d23b226 16.0 landed
Allow logical decoding on standbys
- 0fdab27ad68a 16.0 cited
Fix ts_headline() edge cases for empty query and empty search text.
- 029dea882a7a 16.0 cited
Add a hook for modifying the ldapbind password
- 419a8dd8142a 16.0 cited
Rework design of functions in pg_walinspect
- 5c1b6628075a 16.0 cited
initdb: derive encoding from locale for ICU; similar to libc.
- c45dc7ffbba2 16.0 cited
Doc: add XML ID attributes to <sectN> and <varlistentry> tags.
- 78ee60ed84bb 16.0 cited
Simplify the implementations of the to_reg* functions.
- 3ea7329c9a79 16.0 cited
Rename pg_dissect_walfile_name() to pg_split_walfile_name()
- 13e0d7a60385 16.0 cited
Make materialized views participate in predicate locking
- 43351557d0d2 16.0 cited
Improve performance of and reduce overheads of memory management
- c6e0fe1f2a08 16.0 cited
Allow grant-level control of role inheritance behavior.
- e3ce2de09d81 16.0 cited

On Tue, 23 May 2023 at 06:04, Bruce Momjian <bruce@momjian.us> wrote:
>
> On Mon, May 22, 2023 at 10:59:36AM -0700, Andres Freund wrote:
> > And here it's not just performance, but also memory usage, including steady
> > state memory usage.
>
> Understood.  I continue to need help determining which items to include.
> Can you suggest some text?  This?
>
>         Improve efficiency of memory usage to allow for better scaling

Maybe something like:

* Reduce palloc() memory overhead for all memory allocations down to 8
bytes on all platforms. (Andres Freund, David Rowley)

This allows more efficient use of memory and is especially useful in
queries which perform operations (such as sorting or hashing) that
require more than work_mem.

David