PostgreSQL 10

新特性

官方文件：https://wiki.postgresql.org/wiki/New_in_postgres_10

• 1.1 Big Data（大數據）
  • 1.1.1 Native Partitioning
  • 1.1.2 Additional Parallelism in Query Execution
  • 1.1.3 Additional FDW Push-Down
  • 1.1.4 Faster Analytics Queries
• 1.2 Replication and Scaling（複製和擴展）
  • 1.2.1 Logical Replication
  • 1.2.2 Quorum Commit for Synchronous Replication
  • 1.2.3 Temporary replication slots
  • 1.2.4 Connection Failover and Routing in libpq
  • 1.2.5 Physical Replication
• 1.3 Administration（管理）
  • 1.3.1 Compression support for pg_receivewal
  • 1.3.2 Background processes in pg_stat_activity
  • 1.3.3 Traceable Commit / Status by Transaction-ID
• 1.4 SQL features（SQL 特性）
  • 1.4.1 Identity Columns
  • 1.4.2 Crash Safe, Replicable Hash Indexes
  • 1.4.3 Transition Tables for Triggers
  • 1.5 XML and JSON
  • 1.5.1 XMLTable
  • 1.5.2 Full Text Search support for JSON and JSONB
• 1.6 Security（安全性）
  • 1.6.1 SCRAM Authentication
  • 1.6.2 New "monitoring" roles for permission grants
  • 1.6.3 Restrictive Policies for Row Level Security
• 1.7 Performance（性能）
  • 1.7.1 Cross-column Statistics
  • 1.7.2 Significant Expansion of Wait Events in pg_stat_activity
  • 1.7.3 Query Planner Improvements
• 1.8 Other Features（其他特性）
  • 1.8.1 file_fdw can execute a program
  • 1.8.2 ICU Collation Support
  • 1.8.3 amcheck B-Tree consistency/corruption checking tool
• 1.9 Backwards-Incompatible Changes（不向下兼容的改變）
  • 1.9.1 Change in Version Numbering
  • 1.9.2 Renaming of "xlog" to "wal" Globally (and location/lsn)
  • 1.9.3 Drop Support for FE/BE 1.0 Protocol
  • 1.9.4 Change Defaults around Replication and pg_basebackup
  • 1.9.5 Drop Support for Floating Point Timestamps
  • 1.9.6 Remove contrib/tsearch2
  • 1.9.7 Drop pg_dump Support for Databases Older than 8.0

版本發布說明

簡中版：https://www.postgresql.org/about/press/presskit10/cn/#features