By "pushing down" sorts, joins, and batch data updates, users can distribute workload across multiple PostgreSQL servers. The PostgreSQL-to-PostgreSQL data federation driver, postgres_fdw, has new capabilities to execute work on remote servers. These features support using built-in replication to maintain a set of "identical" nodes for load-balancing read workloads. Second, the "remote_apply" mode creates a more consistent view of data across multiple nodes. First, it now allows configuring groups of synchronous replicas. Two new options have been added to PostgreSQL's synchronous replication feature which allow it to be used to maintain consistent reads across database clusters. Scale Out with Synchronous Replication and postgres_fdw Now with version 9.6, I expect to harness the parallel query functionality to allow even greater scalability for queries against our rather large tables," said Mike Sofen, Chief Database Architect, Synthetic Genomics. "I migrated our entire genomics data platform - all 25 billion legacy MySQL rows of it - to a single Postgres database, leveraging the row compression abilities of the JSONB datatype, and the excellent GIN, BRIN, and B-tree indexing modes. Depending on details and available cores, parallelism can speed up big data queries by as much as 32 times faster. This release includes parallel sequential (table) scan, aggregation, and joins. Version 9.6 adds support for parallelizing some query operations, enabling utilization of several or all of the cores on a server to return query results faster. New features include parallel query, synchronous replication improvements, phrase search, and improvements to performance and usability, as well as many more features. This release will allow users to both scale up and scale out high performance database workloads. PostgreSQL 9.6, the latest version of the world's leading open source database, was released today by the PostgreSQL Global Development Group.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |