PostgreSQL 9.4 has been released (translated)

http://www.postgresql.org/about/news/1557/

December 18, 2014, the PostgreSQL Global Development group released Postgresql9.4,postgresql is the world's leading open source database. For different types of database users, this version adds many new features, including the flexibility to enhance PostgreSQL, scalability and performance, improved support for JSON, data replication, and indexing.

Flexibility
By using the new JSONB data type of PostgreSQL, users no longer need to make a choice between relational and non-relational data stores, but both can be both. JSONB supports fast lookup and simple expression search queries using the generalized Reverse index (GIN). Users can use several new functions to extract and process JSON data, and the performance is comparable or even better than the current popular document database. With JSONB, the data in the table can easily become a complete database integration environment with the document DataSet. "Jsonb in PostgreSQL also provides support for the JavaScript development community, where JSON data can now be queried and stored locally via JS. node. js and other server-side JavaScript frameworks can benefit from the security and robustness of PostgreSQL while storing schema-free data in db. ”。

Scalability
In version 9.4, logical decoding (logical decoding) provides a new API for reading, filtering, and processing data replication streams in PostgreSQL. This interface supports the creation of a multi-master PostgreSQL cluster by providing support for new replication tools, such as bidirectional replication. Other improvements such as replication slots, time-delayed replication, improved replication management, and resource utilization of replication servers are also included in data replication.

Performance
The 9.4 release also introduces a number of performance improvements that will allow users to handle more transactions in a single PostgreSQL server. These include:

• Improved gin indexes, which make them take up 50% less space than before, and have a performance increase of more than 3 times times.
• Faster concurrent updates materialized views, more timely reporting information.
• Use Pg_prewarm to quickly reload the database cache when restarting.
• Faster parallel writes to the PostgreSQL transaction log.
• Linux large memory pages with large memory capacity are supported.

PostgreSQL 9.4 has been released (translated)