Date: Tue, 10 May 2022 20:31:17 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-hackers@postgresql.org
Subject: Re: First draft of the PG 15 release notes
Message-ID: <20220511013117.GG19626@telsasoft.com>
References: <YnqIT8kpiO3m6SD7@momjian.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <YnqIT8kpiO3m6SD7@momjian.us>
User-Agent: Mutt/1.9.4 (2018-02-28)
Archived-At: 
 <https://www.postgresql.org/message-id/20220511013117.GG19626%40telsasoft.com>
Precedence: bulk

| 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'.