发布于 2017-02-10 08:32:36 | 79 次阅读 | 评论: 0 | 来源: 网友投递

这里有新鲜出炉的PostgreSQL指南,程序狗速度看过来!

PostgreSQL关系型数据库管理系统

PostgreSQL是以加州大学伯克利分校计算机系开发的 POSTGRES,现在已经更名为PostgreSQL,版本 4.2为基础的对象关系型数据库管理系统(ORDBMS)。


PostgreSQL 开发组发布了对数据库系统的所有支持版本的更新,包括 9.6.2、9.5.6、9.4.11、9.3.16 和 9.2.20。 此版本包括防止索引构建和某些预写日志重播情况下的数据损坏问题的修复程序,以及超过75个在过去三个月提交的 bug 修复。

重要修复:

修复了可见性和预写日志的稳定性:这些版本包含几个修复,以提高可见数据和WAL日志记录的稳定性。

bug 修复:

  • Several fixes for operating in hot standby mode

  • Disallow setting the num_sync field to zero in synchronous_standby_names

  • Don't count background worker processes against a user's connection limit

  • Fix check for when an extension member object can be dropped

  • Fix tracking of initial privileges for extension member objects so that it works correctly with ALTER EXTENSION ... ADD/DROP

  • Several vacuum and autovacuum fixes

  • Fix CREATE OR REPLACE VIEW to update the view query before attempting to apply the new view options

  • Make sure ALTER TABLE preserves index tablespace assignments when rebuilding indexes

  • Several fixes to the query planner, including fixes for foreign tables and CTEs

  • Several fixes around the full-text search feature to improve accuracy and performance of the search

  • Several fixes and performance improvements in several array functions

  • Several fixes around the interaction of foreign-key constraints with trigger functions around specific ALTER TABLE operations

  • Remove optimizations for date/time data types that returned incorrect data

  • Fix incorrect use of view reloptions as regular table reloptions

  • Fix incorrect "target lists can have at most N entries" complaint when using ON CONFLICT with wide tables

  • Fix spurious "query provides a value for a dropped column" errors during INSERT or UPDATE on a table with a dropped column

  • Prevent multicolumn expansion of foo.* in an UPDATE source expression

  • Ensure that column typmods are determined accurately for multi-row VALUES constructs

  • Several fixes for the psql command-line tool

  • Prevent multiple calls of pg_start_backup() and pg_stop_backup() from running concurrently

  • Several fixes for pg_dump, pg_restore, and pg_basebackup, including a possible pg_basebackup failure on standby server when including WAL files

  • Several fixes for parallel workers and plans for parallel queries including fixing a crash if the number of workers available to a parallel query decreases during a rescan

  • Several fixes to PL/pgSQL, PL/Python, and PL/Tcl

  • Several fixes for contrib modules

  • Allow DOS-style line endings in ~/.pgpass files, even on Unix

详细内容和下载地址请查看发行日志



历史版本 :
PostgreSQL 六版齐发,修复 3 个安全漏洞
PostgreSQL 10 正式版发布,显著的性能提升!
PostgreSQL 10 首个候选版本 RC1 发布,修复部分 bug
PostgreSQL 10 Beta 4 发布,以及全系列更新
PostgreSQL 10 Beta 4 发布,多版本更新
PostgreSQL 10 Beta 3 发布,数据库管理系统
PostgreSQL 10 Beta 3 发布,以及对所有支持版本的更新
PostgreSQL 10 Beta 2 发布,Bug 修复
PostgreSQL 10 首个测试版发布,新增特性一览
PostgreSQL 9.6.3, 9.5.7, 9.4.12, 9.3.17 和 9.2.21 发布
PostgreSQL 10 新增特性
PostgreSQL 五版齐发,修复了超过 75个 bug
最新网友评论  共有(0)条评论 发布评论 返回顶部

Copyright © 2007-2017 PHPERZ.COM All Rights Reserved   冀ICP备14009818号  版权声明  广告服务