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: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-05-10T14:40:45Z
Lists: pgsql-hackers 
Same as the last couple years, I checked for missing items in the release
notes, running something like this.

git log --cherry-pick --oneline origin/REL_13_STABLE...origin/master

Should any of these be included?

f82de5c46b Do COPY FROM encoding conversion/verification in larger chunks.
9e596b65f4 Add "LP_DEAD item?" column to GiST pageinspect functions

10a5b35a00 Report resource usage at the end of recovery
7e453634bb Add additional information in the vacuum error context.
1ea396362b Improve logging of bad parameter values in BIND messages.

86dc90056d Rework planning and execution of UPDATE and DELETE.
a1115fa078 Postpone some more stuff out of ExecInitModifyTable.
c5b7ba4e67 Postpone some stuff out of ExecInitModifyTable.

7db0cd2145 Set PD_ALL_VISIBLE and visibility map bits in COPY FREEZE
01e658fa74 Hash support for row types
a929e17e5a Allow run-time pruning on nested Append/MergeAppend nodes
8c15a29745 Allow ALTER TYPE to update an existing type's typsubscript value.
c7aba7c14e Support subscripting of arbitrary types, not only arrays.

7b94e99960 Remove catalog function currtid()
926fa801ac Remove undocumented IS [NOT] OF syntax.
cd9c1b3e19 Rename PGPROC->vacuumFlags to statusFlags
a04daa97a4 Remove es_result_relation_info from EState.

3d351d916b Redefine pg_class.reltuples to be -1 before the first VACUUM or ANALYZE.
fea10a6434 Rename VariableCacheData.nextFullXid to nextXid.
9de9294b0c Stop archive recovery if WAL generated with wal_level=minimal is found. (see also 15251c0a6)

f40c6969d0 Routine usage information schema tables

b4af70cb21 Simplify state managed by VACUUM.
4753ef37e0 Use a WaitLatch for vacuum/autovacuum sleeping
9dd963ae25 Recycle nbtree pages deleted during same VACUUM.
3c3b8a4b26 Truncate line pointer array during VACUUM.

ad1c36b070 Fix foreign-key selectivity estimation in the presence of constants.

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