What's new in this version: Security Issues: - Too-permissive access control list on function pg_logfile_rotate()
Bug Fixes and Improvements: This update also fixes over 50 bugs reported in the last several months. Some of these issues affect only version 10, but many affect all supported versions. These fixes include: - Fix incorrect volatility and parallel-safety markings on several built-in functions to ensure correct query planning optimizations - Several fixes for partitioning, including potential crashes as well as allowing TRUE and FALSE to be used as partition bounds - Fix where a new TOAST value could be assigned to a dead-but-not-yet-vacuumed TOAST OID, which would result in an error similar to "unexpected chunk number 0 (expected 1) for toast value nnnnn" - Fix "CREATE TABLE ... LIKE" with bigint identity columns on 32-bit platforms - Fix memory leak within the runtime of a query that repeatedly executes hash joins - Several crash fixes around queries using GROUPING SET - Avoid failure if a query-cancel or session-termination interrupt occurs while committing a prepared transaction - Reduce locking during autovacuum worker scheduling, which prevents loss of potential worker concurrency - Fix possible slow execution of REFRESH MATERIALIZED VIEW CONCURRENTLY - Several fixes around query plans that use "index-only" scans - Avoid deadlocks in concurrent CREATE INDEX CONCURRENTLY commands that are run under SERIALIZABLE or REPEATABLE READ transaction isolation - Several fixes for SP-GiST indexes, including one collation-aware searches on text columns - Fixes related to counting the number of tuples in partial GiST, SP-GiST, and Bloom indexes - Several fixes for logical decoding and replication - Fix misquoting of values for list-valued GUC variables (e.g. local_preload_libraries, session_preload_libraries, shared_preload_libraries, temp_tablespaces) in dumps - Several fixes for pg_stat_activity - Several fixes for ecpg - Fix for pg_recvlogical to ensure compatibility with PostgreSQL versions released before 10 - Several fixes for pg_rewind - This update also contains tzdata release 2018d, with updates for Palestine and Antarctica (Casey Station), plus historical corrections for Portugal and its colonies, as well as Enderbury, Jamaica, Turks & Caicos Islands, and Uruguay
PostgreSQL 10.4.1 (64-bit) 相關參考資料
|