PostgreSQL 9.6.1 发布，数据库服务器

PostgreSQL 9.6.1 发布了。

PostgreSQL (也叫 Postgres)是一个自由的对象-关系数据库服务器(数据库管理系统)，它在灵活的 BSD-风格许可证下发行。它提供了相对其他开放源代码数据库系统(比如 MySQL 和 Firebird)，和对专有系统比如 Oracle、Sybase、IBM 的 DB2 和 Microsoft SQL Server的一种选择。

更新内容：

Fix use-after-free hazard in execution of aggregate functions using DISTINCT, which could lead to crashes
Fix incorrect handling of polymorphic aggregates used as window functions, which could lead to crashes
Fix incorrect creation of GIN index WAL records on big-endian machines
Fix file descriptor leakage when truncating a temporary relation of more than 1GB
Fix query-lifespan memory leak in a bulk UPDATE on a table with a PRIMARY KEY or REPLICA IDENTITY index
Fix SELECT FOR UPDATE/SHARE to correctly lock tuples that have been updated by a subsequently-aborted transaction
Fix COPY with a column name list from a table that has row-level security enabled
Fix deletion of speculatively inserted TOAST tuples when backing out of INSERT … ON CONFLICT
Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table
Fix bugs in merging inherited CHECK constraints while creating or altering a table
Fix replacement of array elements in jsonb_set()
Fix possible sorting error when aborting use of abbreviated keys in btree indexes
On Windows, retry creation of the dynamic shared memory control segment after an access-denied error
Fix pgbench’s calculation of average latency

完整版内容，请点击此处查看。

下载地址：