PostgreSQL 9.5 Alpha 1 發布,排序性能提升
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
詳細介紹請看發行說明。
相關鏈接: