PostgreSQL 9.5 Alpha 1 发布,排序性能提升

jopen 6年前

PostgreSQL是一个强大的关系型数据库管理系统,它按照BSD许可[1]发行。PostgreSQL包含很多高级的特性,拥有良好的性能和很好的适用性。

PostgreSQL绑定了很多种编程语言,例如 C, C++, Python, Java, PHP, Ruby等 ,它可以操作很多东西,从简单的Web应用程序到拥有数百万条记录的庞大数据库。

PostgreSQL 9.5 Alpha 1 发布,该版本值得关注的新特性包括:

  • Block-Range Indexes (BRIN) which enable compact indexing of very large tables

  • Large speed improvements in in-memory sorting and hashing

  • Automated management of transaction log size

  • INSERT ON CONFLICT UPDATE, otherwise known as "UPSERT"

  • Grouping Sets, CUBE and ROLLUP analytic operations

  • Row-Level Security (RLS) support

  • More JSONB data manipulation functions and operators

  • Added the pg_rewind tool and other high availability improvements to replication

  • Multiple enhancements to Foreign Data Wrappers, including IMPORT FOREIGN SCHEMA

  • Large increases in multi-core and large memory scalability

详细介绍请看发行说明

相关链接: