PostgreSQL Adds Parallel Query Support
Written by Kay Ewbank   
Wednesday, 05 October 2016

A new version of PostgreSQL has been released with support for parallel queries and synchronous replication on multiple standby servers. Other improvements in Version 9.6 include full-text search for phrases, and improvements to performance.

 

postgresqlsq

 

PostgreSQL is an open source database system that was originally created at the University of California, Berkeley. It is now maintained and developed by the PostgreSQL Global Development Group, a coalition of many companies and individual contributors.

The headline improvement of the Postgre SQL 9.6 is the new support for parallel running of some query operations on several or all of the cores on a server to return query results faster. This release includes parallel sequential table scans, aggregation, and joins, and the developers say that depending on details such as how many cores are available, the parallel query support can make big data queries run as much as 32 times faster.

Another improvement is to the replication feature. This now has two new options. You can now configure groups of synchronous replicas, and there's a new "remote_apply" mode that creates a more consistent view of data across multiple nodes. The combination means you can maintain a set of "identical" nodes for load-balancing read workloads.

The other main change is the addition of the ability to search for phrases in PostgreSQL's full text search. This means that users can search for exact phrases, or for words within a specified proximity to each other, using fast GIN indexes.

Elsewhere in the new release, replication, aggregation, indexing, sorting, and stored procedures have all been made more efficient, and resources with recent Linux kernels are better managed.

postgresqlsq

More Information

PostgreSQL Release Notes

PostgreSQL Downloads

Related Articles

PostgreSQL Version 9.5

PostgreSQL 9.4 Released

PostgreSQL Plus Cloud Database

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter,subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin

 

Banner


Stack Overflow On Google Cloud
06/03/2024

Stack Overflow and Google Cloud have announced a partnership to deliver new gen AI-powered capabilities to developers through the Stack Overflow platform, Google Cloud Console, and Gemini for Google C [ ... ]



Golang Back In TIOBE Top 10
21/02/2024

Google's system language Go is ranked #8 in the TIOBE Index for February 2024. This is the third time it has entered the Top 10. However, it is now in the highest position it has ever had to date.


More News

 

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Thursday, 06 October 2016 )