軟體下載 PostgreSQL 12.10

• 1

  版本確認

• 2

  檔案準備中

• 3

  檔案下載

What's new in this version:

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