Horton

Re: First draft of the PG 15 release notes

Matthias van de Meent <boekewurm+postgres@gmail.com>

View thread View on postgr.es
From: Matthias van de Meent <boekewurm+postgres@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2022-05-11T12:19:20Z
Lists: pgsql-hackers 
On Tue, 10 May 2022 at 17:44, Bruce Momjian <bruce@momjian.us> wrote:
>
> I have completed the first draft of the PG 15 release notes and you can
> see the results here:
>
>         https://momjian.us/pgsql_docs/release-15.html
>
> The feature count is similar to recent major releases:
>
>         release-10 195
>         release-11 185
>         release-12 198
>         release-13 183
>         release-14 229
> -->     release-15 186
>
> I assume there will be major adjustments in the next few weeks based on
> feedback.

With 10a8d138 (an extension on the work of PG14's 3c3b8a4b, which was
listed in the release notes for PG14) we now truncate the LP array in
more cases, which means that overall a workload with mainly HOT
updates might require VACUUM to run less often to keep the relation
size stable.

I will admit that I am tooting my own horn, but I think it is worth
mentioning for DBAs, as it reduces the bloating behaviour of certain
classes of bloat-generating workloads (and thus they might need to
re-tune any vacuum-related settings).

-Matthias

Commits

  1. Doc: last minute adjustment to the release notes

  2. Doc: more tweaking of v15 release notes.

  3. Doc: further adjust notes about pg_upgrade_output.d.

  4. Doc: add list of major features to the v15 release notes.

  5. relnotes: update item about public schema permission change

  6. relnotes: update ordered partition scan item

  7. relnotes: add Heikki to UTF8 item

  8. relnotes: improve UTF8 text item in relation to ASCII

  9. relnotes: add null logical replication item

  10. relnotes: adjust several logical replication items and FK text

  11. relnotes: mention non-exclusive backup mode was deprecated

  12. relnotes: add author to in-memory sorts item

  13. relnotes: update for non-exclusive backup mode removal

  14. relnote: improve sorting entries

  15. relnotes: adjustments from Álvaro Herrera

  16. relnotes: update foreign key partition and add sort items

  17. relnotes: more adjustments

  18. relnotes: logical replication permissions checked by subscrib.

  19. relnotes: adjustments

  20. relnotes: remove sequence replication and update 'postgres -C'

  21. relnote: extensive updates

  22. relnotes: "training" -> "trailing"

  23. Standardize references to Zstandard as <productname>

  24. pgstat: Update docs to match the shared memory stats reality.

  25. Raise a WARNING for missing publications.

  26. Skip empty transactions for logical replication.

  27. Optionally disable subscriptions on error.

  28. Allow root-owned SSL private keys in libpq, not only the backend.

  29. Use COPY FREEZE in pgbench for faster benchmark table population.