PostgreSQL 9.4 Released
Written by Kay Ewbank   
Monday, 22 December 2014

The PostgreSQL Global Development Group has released PostgreSQL 9.4, with improved JSON support, replication and index performance.

postgreSQL94

 

PostgreSQL is the open source database system that was originally created at the University of California, Berkeley. The JSON support in the new version comes via a new JSONB data type for PostgreSQL that supports fast lookups and simple expression search queries using Generalized Inverted Indexes (GIN). There are also new support functions that you can use to extract and manipulate JSON data. The announcement of the new version says that the functions provide a performance that matches or surpasses the most popular document databases, adding “with JSONB, table data can be easily integrated with document data for a fully integrated database environment”. The new data type means you can store and query JSON data natively in PostgreSQL, without needing to move to a schema-based format.

The new version also adds a new API (Logical Decoding) for reading, filtering and manipulating the PostgreSQL replication stream. The API is the foundation for new replication tools including bi-directional replication, so you can create multi-master PostgreSQL clusters. Other improvements in the replication system, such as replication slots and time-delayed replicas, improve management and utility of replica servers.

Version 9.4 also adds several performance improvements, including improvements to GIN indexes, making them up to 50% smaller and up to 3X faster; concurrently updatable Materialized Views for faster, more up-to-date reporting; the ability to rapidly reload the database cache on restart using pg_prewarm; faster parallel writing to the PostgreSQL transaction log; and support for Linux Huge Pages for servers with large memory.

 postgreSQLsq

 

 

 

More Information

PostgreSQL

Download PostgreSQL

What's new in PostgreSQL 9.4

Related Articles

PostgreSQL 9.3 Released

 

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

 

Banner


Visual Studio 2022 Preview 4 - More Productivity
22/09/2021

Visual Studio 2022 Preview 4 has been released with more support for personal and team productivity, along with support for 'modern development' according to the Visual Studio team.



Google Announces Cloud Deploy For Kubernetes Engine
27/09/2021

Google has announced a new managed application delivery service for Google Kubernetes Engine (GKE). Google Cloud Deploy is described as a managed, opinionated continuous delivery service that makes co [ ... ]


More News

 

square

 



 

Comments




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

Last Updated ( Monday, 22 December 2014 )