PostgreSQL 11 beta 2 發布了,PostgreSQL (也叫 Postgres)是一個自由的對象-關係資料庫伺服器(資料庫管理系統),它在靈活的 BSD-風格許可證下發行。它提供了相對其他開放原始碼資料庫系統(比如 MySQL 和 Firebird),和對專有系統比如 Oracle、Sybase、IBM 的 DB2 和 Microsoft SQL Server的一種選擇。
此版本修復了眾多 bug:
Several fixes for XML support, including using the document node as the context for XPath queries as defined in the SQL standard, which affects the xpath
and xpath_exists
functions, as well as XMLTABLE
Several fixes related to VACUUM, including potential data corruption issues
Fixes for partitioning, including ensuring partitioning works with temporary tables, eliminating a needless additional partition constraint checks on INSERT
s and generating incorrect paths for partitionwise aggregates
Fix for potential replica server crashes where a replica would attempt to read a recycled WAL segment
Fixes for pg_replication_slot_advance
including returning NULL
if slot is not advanced and changes for how the slot is updated depending on if it is a physical or logical replication slot
Ensure pg_resetwal
works with relative paths to data directory
Fixes for query parallelism, including preventing a crash by ignoring "parallel append" for parallel unsafe paths in a query plan
Fix returning accurate results with variance
and similar aggregate functions when executed using parallel query
Fix issue where COPY FROM .. WITH HEADER
would drop a line after every 4,294,967,296 lines processed
Ensure the "B" (bytes) parameter is accepted by all memory-related configuration parameters
Several fixes for the JSONB transform in PL/Python and PL/Perl
Fix for plpgsql checking statements where it needs to check original write statement before rewrite, could cause crash
Fix for SHOW ALL
to display superuser configuration settings to roles that are allowed to read all settings
Fix for pg_upgrade
that ensures defaults are written when using the "fast ALTER TABLE .. ADD COLUMN" feature with a non-NULL default
Several fixes for memory leaks
Several fixes specific to the Windows platform
同時包含 tzdata 版本 2018e。
詳情查看發布公告。
下載地址:https://www.postgresql.org/download/