New Community Version of PostgreSQL 9.6 Boosts Performance with Parallel Query and Vertical and Horizontal Scalability Features
BEDFORD, Mass. – September 29, 2016 EnterpriseDB, the leading enterprise Postgres database company, congratulates the PostgreSQL Global Development Group for the newly released PostgreSQL 9.6. The new 9.6 version features parallel processing capabilities and expands scale up and scale out capacity to support more complex workloads and data infrastructures distributed across multiple or remote data sources.
Members of EDB’s staff worked as part of the PostgreSQL Community to develop performance advances for PostgreSQL 9.6 that will extract greater efficiency from todays hardware for larger and more complex workloads,” said Marc Linster, Senior Vice President, Product Development. “Based on contributions from EDB and the community at large, PostgreSQL 9.6 will benefit EDB customers that require parallel processing.
Advances in PostgreSQL 9.6 move the database deeper into analytics, addressing long-time bottlenecks that have made it difficult to run PostgreSQL on larger data sets. Enhancements to the freeze map, for example, allow PostgreSQL to scale up further than ever before, while new parallel query facilities make it possible to use multiple CPU cores to accelerate response times for queries that touch a lot of data. Expanded replication capabilities make it possible to build a truly reliable multi-node read scaling cluster based on PostgreSQL. Full-text searching enhancements help make PostgreSQL more effective with document stores and now supports the ability to search for words based on proximity, which helps lexical and forensic applications.
Scalability enhancements to PostgreSQL 9.6 that improve performance include:
Parallel Sequential Scans, Joins, and Aggregates: These features improve query performance on today’s multi-core servers by enabling PostgreSQL to utilize multiple cores in a server. This improves query performance on today’s increasingly powerful hardware, particularly for CPU-intensive queries that benefit from using all cores on a server. These vertical scalability, or scale up, features are an important advance for PostgreSQL and will support the development of more advanced parallel processing capabilities in later releases.
Enhancement to Freeze Map using Autovacuum: PostgreSQL’s Freeze Map features track data blocks that do not require vacuuming, thereby avoiding unnecessary multiple scans of data. This scale up enhancement saves I/O overhead and results in more efficient use of hardware for greater overall performance and scalability.
Support for Remote Joins, Sorts, and Updates in Postgres_fdw: The Foreign Data Wrapper (FDW) feature in PostgreSQL that links the database to external data sources, has been enhanced to increase query performance when it is used to connect multiple Postgres databases. postgres_fdw can now “push down” some query logic to remote servers to better distribute workloads, and use the foreign database server to perform the query operations. With this predicate push down of sorts, joins, and batch data updates, users can distribute workloads across multiple servers, and expand the database’s horizontal, or scale out, capacity.
Synchronous Replication Enhancements: Synchronous replication now allows multiple synchronous standbys that have the option to wait for transactions to be applied (rather than received). This allows better consistency across database clusters and expands horizontal scalability for read-only transactions to identical replicas. This also improves disaster recovery architectures.
PostgreSQL 9.6 also includes several enhancements that assist developers and database administrators:
Full Text Search for Phrases: This feature improves the text search capabilities of PostgreSQL and makes it a better alternative to dedicated text search technologies that some companies use to search the web and mine data.
Exposed Wait States: An improved pg_state_activity system view more effectively supports troubleshooting and helps DBAs diagnose problems with queries and resolve issues.
EDB is bundling pgAdmin 4 with PostgreSQL 9.6 in its one-click installers of the database.
EDB is honored to have made code contributions to some of the major features in the PostgreSQL 9.6 release. EDB also partners with other companies that work with and use PostgreSQL to drive continual improvement of PostgreSQL, the world’s most advanced open source database.
PostgreSQL 9.6 is now available. To download the free version of PostgreSQL using an easy one-click installer visit the www.postgresql.org community download page. To leverage the full value of PostgreSQL for enterprise deployments, the database also is available as part of the EDB Postgres Standard subscription.