Posted on 2016-09-29
PostgreSQL 9.6, the latest version of the world’s leading open source database, was released today by the PostgreSQL Global Development Group. This release will allow users to both scale up and scale out high performance database workloads. New features include parallel query, synchronous replication improvements, phrase search, and improvements to performance and usability, as well as many more features.
Scale Up with Parallel Query
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. This release includes parallel sequential (table) scan, aggregation, and joins. Depending on details and available cores, parallelism can speed up big data queries by as much as 32 times faster.
“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,
Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/Lg1Bwi4EvnU/