postgresql 9.6 主要升级内容

Parallel sequential scans, joins and aggregates
Support for consistent, read-scaling clusters through multiple synchronous standbys and "remote_apply" synchronous commit.
Full text search for phrases
postgres_fdw can now execute sorts, joins, UPDATEs and DELETEs on the remote server
Decreased autovacuum impact on big tables by avoiding "refreezing" old data.

• 并行连续扫描，连接和聚合
• 全文搜索支持短语
• 减少autovacuum对大表的冲击避免冻结旧数据。
• 通过多个同步的备用服务器和“remote_apply”同步提交技术支持数据一致的，读操作可伸缩的集群

Major enhancements in PostgreSQL 9.6 include:

Parallel execution of sequential scans, joins and aggregates

Avoid scanning pages unnecessarily during vacuum freeze operations

Synchronous replication now allows multiple standby servers for increased reliability

Full-text search can now search for phrases (multiple adjacent words)

postgres_fdw now supports remote joins, sorts, UPDATEs, and DELETEs

Substantial performance improvements, especially in the area of scalability on multi-CPU-socket servers

安装 postgresql 9.6(centos 7)

• 安装 postgresql 官方库

yum install https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/pgdg-redhat96-9.6-3.noarch.rpm

• 安装 数据库

yum install postgresql96-server

• 安装 扩展包

 yum install postgresql96-contrib

• 进行数据库初始化

postgresql96-setup initdb

启动 postgresql

systemctl enable postgresql-9.6.service
systemctl start postgresql-9.6.service