Parallel Query Support Coming To PostgreSQL 9.6

Written by Michael Larabel in Free Software on 11 November 2015 at 03:12 PM EST. 8 Comments
FREE SOFTWARE
For PostgreSQL users, the next 9.6 release should be particularly exciting as the parallel sequential scan / parallel query support has been committed.

This parallel sequential scan support has the ability to significantly improve the performance of selects on PostgreSQL databases. In one of the examples, a database select query dropped from taking 743 ms to now taking just 213 ms.

This parallel query code is still a work-in-progress, but the initial support will be found in PostgreSQL 9.6. More details via today's blog post by developer Robert Haas.
Related News
About The Author
Michael Larabel

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.

Popular News This Week