PostgreSQL Improves Declarative Partitioning
Written by Kay Ewbank   
Monday, 02 October 2017

The first release candidate of PostgreSQL 10.0 is now available, with improvements including logical replication and improved query parallelism.


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 improvements to the new version start with support for logical replication using publish/subscribe. The addition is designed to let you replicate only part of the primary server or write to the secondary if there's a need. The way it works is that on the primary, you create a publication of the tables you want to replicate. On the secondary, you create tables identical to those you're replicating, then set up a subscription to the original tables.

The next improvement is support for declarative table partitioning. This adds commands to create range and list *partitioned* tables and their partitions, though you can't create indexes, row-level triggers, etc. on the partitioned parent table.

The improvements to the parallel query facilities start with the addition of support for parallel merge joins. In the previous release, only hash joins and nested loops can be performed in the parallel portion of a plan. In PostgreSQL 10, merge joins can also be performed in the parallel portion of the plan.

A parallel bitmap heat scan has been added where one process scans the index and builds a data structure in shared memory indicating all of the heap pages that need to be scanned, and then all cooperating processes can perform the heap scan in parallel.

You can now carry out parallel index scans and index-only scans, and a table with an uncorrelated subplan can appear in the parallel portion of the plan.

Other improvements include what the developers say are 'significant' general performance improvements; stronger password authentication based on SCRAM-SHA-256; and improved monitoring and control.

postgresqlsq

More Information

Whats New In PostrgreSQL 10

PostgreSQL Downloads Page 

Related Articles

PostgreSQL Adds Parallel Query Support

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, Facebook or Linkedin.

 

Banner


GitHub Releases Projects
04/08/2022

GitHub has announced the general availability of GitHub Projects powered by GitHub Issues. The developers say GitHub Projects connects your planning directly to the work your teams are doing in GitHub [ ... ]



Python Continues Its Rise on TIOBE Index
10/08/2022

The TIOBE Community Index which ranks programming languages in terms of their popularity has just had its regular monthly update and the August headline reads "Python going through the roof".


More News

 

pythondata

 



 

Comments




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

Last Updated ( Monday, 02 October 2017 )