軟體下載 PostgreSQL 10.4.1 (64-bit)

• 1

  版本確認

• 2

  檔案準備中

• 3

  檔案下載

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