Log message:
postgresql1N: updated to 14.2, 13.6, 12.10, 11.15, and 10.20
PostgreSQL 14.2, 13.6, 12.10, 11.15, and 10.20 Released!
This update fixes over 55 bugs that were reported in the last several months. \
The issues listed below affect PostgreSQL 14. Some of these issues may also \
affect other supported versions of PostgreSQL.
Included in this release:
Fix for a low probability scenario of index corruption when a HOT (heap-only \
tuple) chain changes state during VACUUM. Encountering this issue is unlikely, \
but if you are concerned, please consider reindexing.
Fix for using REINDEX CONCURRENTLY on TOAST table indexes to prevent corruption. \
You can fix any TOAST indexes by reindexing them again.
The psql \password command now defaults to setting the password for the role \
defined by CURRENT_USER. Additionally, the role name is now included in the \
password prompt.
Build extended statistics for partitioned tables. If you previously added \
extended statistics to a partitioned table, you should run ANALYZE on those \
tables. As autovacuum currently does not process partitioned tables, you must \
periodically run ANALYZE on any partitioned tables to update their statistics.
Fix crash with ALTER STATISTICS when the statistics object is dropped concurrently.
Fix crash with multiranges when extracting variable-length data types.
Several fixes to the query planner that lead to incorrect query results.
Several fixes for query plan memoization.
Fix startup of a physical replica to tolerate transaction ID wraparound.
When using logical replication, avoid duplicate transmission of a partitioned \
table's data when the publication includes both the child and parent tables.
Disallow altering data type of a partitioned table's columns when the \
partitioned table's row type is used as a composite type elsewhere.
Disallow ALTER TABLE ... DROP NOT NULL for a column that is part of a replica \
identity index.
Several fixes for caching that correct logical replication behavior and improve \
performance.
Fix memory leak when updating expression indexes.
Avoid leaking memory during REASSIGN OWNED BY operations that reassign ownership \
of many objects.
Fix display of whole-row variables appearing in INSERT ... VALUES rules.
Fix race condition that could lead to failure to localize error messages that \
are reported early in multi-threaded use of libpq or ecpglib.
Fix psql \d command for identifying parent triggers.
Fix failures on Windows when using the terminal as data source or destination. \
This affected the psql \copy command and using pg_recvlogical with -f -.
Fix the pg_dump --inserts and --column-inserts modes to handle tables that \
contain both generated and dropped columns.
Fix edge cases in how postgres_fdw handles asynchronous queries. These errors \
could lead to crashes or incorrect results when attempting to run parallel scans \
of foreign tables.
For the full list of changes available, please review the release notes.
|
Log message:
postgresql14: added version 14.0
PostgreSQL 14 contains many new features and enhancements, including:
Stored procedures can now return data via OUT parameters.
The SQL-standard SEARCH and CYCLE options for common table expressions have been \
implemented.
Subscripting can now be applied to any data type for which it is a useful \
notation, not only arrays. In this release, the jsonb and hstore types have \
gained subscripting operators.
Range types have been extended by adding multiranges, allowing representation of \
noncontiguous data ranges.
Numerous performance improvements have been made for parallel queries, \
heavily-concurrent workloads, partitioned tables, logical replication, and \
vacuuming.
B-tree index updates are managed more efficiently, reducing index bloat.
VACUUM automatically becomes more aggressive, and skips inessential cleanup, if \
the database starts to approach a transaction ID wraparound condition.
Extended statistics can now be collected on expressions, allowing better \
planning results for complex queries.
libpq now has the ability to pipeline multiple queries, which can boost \
throughput over high-latency connections.
|