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


Dart Adds WebAssembly Support
20/02/2024

Google has released Dart 3.3 with experimental support for applications compiled to WebAssembly, along with new extension types and a revamped JavaScript interop model.



PostgresML - Bring Your ML Workload To The Database
23/01/2024

PostgresML is a machine learning extension for PostgreSQL that lets you perform training and inference on text and tabular data using SQL queries. It opens up intriguing possibilities. Let's find [ ... ]


More News

 

raspberry pi books

 

Comments




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

Last Updated ( Monday, 22 December 2014 )