PostgreSQL 9.2 Released
PostgreSQL 9.2 Released
Written by Kay Ewbank   
Thursday, 13 September 2012

The PostgreSQL project has announced the release of PostgreSQL 9.2 with improved scalability and developer flexibility.

The release of PostgreSQL 9.2 has been announced by the PostgreSQL Global Development Group. Making the announcement, Ines Sombra, Lead Data Engineer at Engine Yard, said:

"PostgreSQL 9.2 will ship with native JSON support, covering indexes, replication and performance improvements, and many more features.”

The performance improvements come via support for up to 64 cores, alongside better lock management and index-only access. Read queries are four times faster while index-only scans for data warehousing queries are between two and 20 times faster.

On the developer side, the main changes are support for range restricted types and JSON. Range Types let you work more effectively with dates, times series and financial data for analysis. You can also create your own custom range types. The support for JSON data types meaning you can store JSON documents, and JSON functions let you convert array and row data into JSON format. Query results can be returned as JSON data types.

Other improvements for developers are extensions for PL/V8 JavaScript and PL/Coffee, and an optional HStore key-value store. These are designed to let you develop apps that use PostgreSQL as though it’s a NoSQL document database.

 

More Information

What's new in PostgreSQL 9.2

Download PostgreSQL

Related Articles

MemSQL - 80,000 queries per second

SQL Fiddle

Performance enhancements in PostgreSQL 9.2

PostgreSQL Plus Cloud Database

 

justjsquare

 



 

Comments




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

 

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

 

Banner


Bayou - AI To Help You Code
02/05/2018

Programmers tend to imagine that we will be last to be displaced by AI - after all we are part of the team actually making this stuff! In fact, we are likely to see AI programming assistants sooner th [ ... ]



Facebook Advances in AI At F8
04/05/2018

Facebook is one of the big technology companies that is making a big investment in AI and at F8 it was ready to share some of its latest progress. The good news is that Facebook is open-sourcing its A [ ... ]


More News

Last Updated ( Thursday, 13 September 2012 )
 
 

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