Horton

Re: PG 14 release notes, first draft

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: 2021-05-19T14:39:08Z
Lists: pgsql-hackers 
These sound weird since markup was added in 6a5bde7d4:
https://www.postgresql.org/docs/devel/release-14.html
| Remove server and Chapter 34 support for the version 2 wire protocol (Heikki Linnakangas)
...
| Pass doubled quote marks in Chapter 36 SQL command strings literally (Tom Lane)

-Remove server and libpq support for the version 2 wire protocol (Heikki Linnakangas)
+Remove server and <xref linkend="libpq"/> support for the version 2 <link linkend="protocol">wire protocol</link> (Heikki Linnakangas)

> Force custom server variable names to match the pattern used for unquoted SQL identifiers (Tom Lane)
Say "Require" not force?

> This setting was disabled in PostgreSQL version 13.3.
"disabled" sounds like it was set to "off".  Maybe say it was ignored.

> Add long-running queries to be canceled if the client disconnects (Sergey Cherkashin, Thomas Munro)
Should say: Allow

> The server variable client_connection_check_interval allows supporting operating systems, e.g., Linux, to automatically cancel queries by disconnected clients.
say "some operating systems" ?

> This can be disabled by turning client option "sslsni" off.
"turning off"

| Add %P to log_line_prefix to report the parallel group leader (Justin Pryzby)

Maybe it should say "Allow %P in log_line_prefix to ...", otherwise it sounds
like the default was changed.

| Reduce the default value of vacuum_cost_page_miss (Peter Geoghegan) 
|  This new default better reflects current hardware capabilities. 
Also say: the previous default was 10.

Commits

  1. doc: add mention of +4GB windows file handling in PG14 relnotes

  2. doc: PG 14 relnotes fixes

  3. doc: PG 14 relnote updates

  4. doc: PG 14 relnotes, adjust pg_{read|write}_all_data entry

  5. Update PG 14 relnotes for vacuum_cost_page_miss

  6. doc: update PG 14 release notes with recent feedback

  7. Update replication statistics after every stream/spill.

  8. Add information of total data processed to replication slot stats.

  9. Use NameData datatype for slotname in stats.

  10. Add back vacuum_cleanup_index_scale_factor parameter.

  11. Don't consider newly inserted tuples in nbtree VACUUM.

  12. pgbench: Improve time logic.

  13. Track total amounts of times spent writing and syncing WAL data to disk.

  14. Allow decoding at prepare time in ReorderBuffer.

  15. Extend the output plugin API to allow decoding of prepared xacts.

  16. Fix nbtree cleanup-only VACUUM stats inaccuracies.

  17. Execute invalidation messages for each XLOG_XACT_INVALIDATIONS message

  18. Fix our Windows stat() emulation to handle file sizes > 4GB.

  19. Trigger autovacuum based on number of INSERTs

  20. Speed up planning when partitions can be pruned at plan time.

  21. Remove support for password_encryption='off' / 'plain'.

  22. Increase work_mem and maintenance_work_mem defaults by 4x