Performance enhancements in PostgreSQL 9.2
Performance enhancements in PostgreSQL 9.2
Written by Kay Ewbank   
Thursday, 17 May 2012

The beta release of the next version of the PostgreSQL database has been announced, with improvements in performance as the main highlight.

The performance improvements to PostgreSQL 9.2 start with the addition of index-only scans. This means your queries can retrieve data only from indexes without the need to scan base tables. This is obviously faster, and is possible so long as the data is all visible in the heap pages.

Where the workload is read-only, the new version has been improved to enable it to make use of up to 64 cores and to run over 300,000 queries per second. The data write speeds have also been improved, including group commit.

Cascading replication is now supported so you can work with geographically distributed standby databases.

From the developer viewpoint the new release makes it easier to work with hybrid databases containing both relational and document-based databases thanks to the addition of support for JSON data types meaning you can store JSON documents. JSON functions have also been added that can be used to convert array and row data into JSON.

Range data types have also been added that will let you store dates, time series and analytic data. You can also create custom range types.

The final release version is intended to be available in September.

 

More Information

New features of PosgreSQL 9.2

Download beta

Related Articles

Synchronous replication in Postgre SQL 9.1

 

 
 

 

blog comments powered by Disqus

 

To be informed about new articles on I Programmer, subscribe to the RSS feed, follow us on Google+, Twitter, Linkedin or Facebook, install the I Programmer Toolbar or sign up for our weekly newsletter.

 

Banner


Google Starts Its Push To Progressive Web Apps - Bye Bye Chrome Apps
06/12/2017

Google has removed Chrome apps from the Chrome Web Store and has made it clear that Progressive Web Apps are what you should move to. There is a lot that is unclear about all of this and, apart from a [ ... ]



Exploring AlphaGo Teach
13/12/2017

DeepMind has released AlphaGo Teach, an interactive tool that can be used to explore the opening moves of a game of Go. It lets you try out alternative moves and shows the probabilities of a win  [ ... ]


More News

Last Updated ( Thursday, 17 May 2012 )
 
 

   
Banner
RSS feed of news items only
I Programmer News
Copyright © 2017 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.