Horton

Re: First draft of the PG 15 release notes

Justin Pryzby <pryzby@telsasoft.com>

View thread View on postgr.es
From: Justin Pryzby <pryzby@telsasoft.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-hackers@postgresql.org
Date: 2022-05-11T01:31:17Z
Lists: pgsql-hackers 
| Remove incorrect duplicate partition tables in system view pg_publication_tables (Hou Zhijie)

should say "partitions" ?
"Do not show partitions whose parents are also published" (is that accurate?)

| Allow system and TOAST B-tree indexes to efficiently store duplicates (Peter Geoghegan)
| Previously de-duplication was disabled for these types of indexes. 

I think the user-facing change here is that (in addition to being "allowed"),
it's now enabled by default for catalog indexes.  "Enable de-duplication of
system indexes by default".

| Prevent changes to columns only indexed by BRIN indexes from preventing HOT updates (Josef Simanek)

says "prevent" twice.
"Allow HOT updates when changed columns are only indexed by BRIN indexes"
(or "avoid precluding...")

| Improve the performance of window functions that use row_number(), rank(), and count() (David Rowley)

The essential feature is a new kind of "prosupport", which is implemented for
those core functions. I suggest to add another sentence about how prosupport
can also be added to user-defined/non-core functions.

| Store server-level statistics in shared memory (Kyotaro Horiguchi, Andres Freund, Melanie Plageman)

Should this be called "cumulative" statistics?  As in b3abca68106d518ce5d3c0d9a1e0ec02a647ceda.

| Allows view access to be controlled by privileges of the view user (Christoph Heiss)

Allow

| New function

"The new function .." (a few times)

| Improve the parallel pg_dump performance of TOAST tables (Tom Lane) 

I don't think this needs to be mentioned, unless maybe folded into an entry
like "improve performance when dumping with many objects or relations with
large toast tables".

| Allow pg_basebackup to decompress LZ4 and Zstandard compressed server-side base backups, and LZ4 and Zstandard compress output files (Dipesh Pandit, Jeevan Ladhe) 

maybe: "... and to compress output files with LZ4 and Zstandard."

|  Add direct I/O support to macOS (Thomas Munro)
| This only works if max_wal_senders=0 and wal_level=minimal. 

I think this should mention that it's only for WAL.

| Remove status reporting during pg_upgrade operation if the output is not a terminal (Andres Freund)

Maybe: "By default, do not output status information unless the output is a terminal"

| Add new protocol message COMPRESSION and COMPRESSION_DETAIL to specify the compression method and level (Robert Haas)

s/level/options/ ?

| Prevent DROP DATABASE, DROP TABLESPACE, and ALTER DATABASE SET TABLESPACE from occasionally failing during concurrent use on Windows (Thomas Munro)

Maybe this doesn't need to be mentioned ?

| Fix pg_statio_all_tables to sum values for the rare case of TOAST tables with multiple indexes (Andrei Zubkov)
| Previously such cases would have one row for each index. 

Doesn't need to be mentioned ?
It doesn't seem like a "compatibility" issue anyway.

Should this be included?
6b94e7a6da2 Consider fractional paths in generate_orderedappend_paths

Should any of these be listed as incompatible changes (some of these I asked
before, but the others are from another list).

95ab1e0a9db interval:  round values when spilling to months
9cd28c2e5f1 Remove server support for old BASE_BACKUP command syntax.
0d4513b6138 Remove server support for the previous base backup protocol.
ccd10a9bfa5 Fix enforcement of PL/pgSQL variable CONSTANT markings (Tom Lane)
38bfae36526 pg_upgrade: Move all the files generated internally to a subdirectory
376ce3e404b Prefer $HOME when looking up the current user's home directory.
7844c9918a4 psql: Show all query results by default
17a856d08be Change aggregated log format of pgbench.
? 73508475d69 Remove pg_atoi()
? aa64f23b029 Remove MaxBackends variable in favor of GetMaxBackends() function.
? d816f366bc4 psql: Make SSL info display more compact
? 27b02e070fd pg_upgrade: Don't print progress status when output is not a tty.
? ab4fd4f868e Remove 'datlastsysoid'.

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.