Open source database PostgreSQL released v9.2

PostgreSQL is a famous open-source database. Recently, the PostgreSQL Global Development Team released the latest version 9.2, which greatly improved the performance and added built-in support for JSON.

As early as the release of beta in March, the team's chief data engineer Ines Sombra made a commitment:

PostgreSQL 9.2 comes with local JSON support. The new features involve indexing, replication, and performance improvement.

PostgreSQL 9.2 supports horizontal scaling to 64 cores. It can only scan indexes (index-only) and reduce CPU power consumption, this significantly improves the scalability and developer flexibility under most workloads. The improvement in vertical scalability allows PostgreSQL to more effectively apply hardware resources on large servers, in Lock Management, write efficiency, index-only access, and other low-level operations, the database engine can handle a large amount of workload.

These performance improvements are represented in numbers:

• Up to 350,000 read queries per second (more than 4 times faster)
• Only index scans for Data Warehouse queries (2-20 times faster)
• Up to 14,000 data writes per second

In addition, PostgreSQL 9.2 further supports development flexibility, including support for the range type and JSON, allowing developers to use PostgreSQL in a completely different way.

The range type allows developers to create calendar-related, scientific, and financial applications.Program. No other mainstream databases support this feature. In PostgreSQL, query results can be returned in JSON Data Type format. You can combine this technology with pL/V8 JavaScript and PL/coffee database programming extensions and the optional hstore key-value database to use it as a "nosql" document database, it also retains the reliability, flexibility, and performance advantages of PostgreSQL.

 

The PostgreSQL Global Development Group announces PostgreSQL 9.2, the latest release of the leader in open source databases. since the beta release was announced in May, developers and vendors have praised it as a leap forward in performance, scalability and flexibility. users are expected to switch to this version in record numbers.

"PostgreSQL 9.2 will ship with native JSON support, covering indexes, replication and performance improvements, and more features. we are eagerly awaiting this release and will make it available in early access as soon as it's released by the PostgreSQL community, "said Ines Sombra, lead data engineer, Engine Yard.

Links

• Downloads, including packages and installers
• Release Notes
• Documentation
• What's new in 9.2
• Press kit

Improved performance and scalability

With the addition of linear scalability to 64 cores, index-only scans and functions in CPU power consumption, PostgreSQL 9.2 has significantly improved scalability and developer flexibility for the most demaning workloads. organizations like the U. s. federal Aviation Administration and heroku.com run applications on PostgreSQL, and HP has adopted it for their remote support software and to power their HP-UX/itanium solutions.

Improvements in vertical scalability increase PostgreSQL's ability to efficiently utilize hardware resources on larger servers. advances in lock management, write efficiency, index-only access and other low-level operations allow the database engine to handle even larger-volume workloads.

Numerically, this means:

• Up to 350,000 read queries per second (more than 4x faster)
• Index-only scans for Data Warehousing queries (2-20x faster)
• Up to 14,000 data writes per second (5x faster)

Also, the addition of cascading replication enables users to run even larger stacks of Horizontally scaled servers under PostgreSQL 9.2.

"Newsblur, a social news reader, relies on Postgres for storing millions of sites and subscriptions. solid and reliable for years, "said Samuel clay, founder of newsblur.com. "We're consistently on the bleeding edge (9.1 now, moving to 9.2 soon for the cascading replication alone) and it's been a pleasure since 8. 4."

Flexible Developer support

The flexibility of PostgreSQL is reflected in the diversity of organizations that have adopted it. for example NASA, the Chicago Mercantile Exchange and Instagram all rely on it to perform mission-critical applications. version 9.2 extends this flexibility even further by including support for range types and JSON, allowing developers to use PostgreSQL in completely new ways.

Range types allow developers to create better Calendaring, scientific, and financial applications. No other major SQL database supports this feature, which enables intelligent handling of blocks of time and numbers.

With PostgreSQL 9.2, query results can be returned as JSON data types. combined with the new PL/V8 JavaScript and PL/coffee database programming extensions, and the optional hstore key-Value Store, users can now utilize PostgreSQL like a "nosql" document database, while retaining PostgreSQL's reliability, flexibility and performance.

"Native JSON support in postgressql provides an efficient mechanic for creating and storing documents for Web APIs. we use front-end libraries like jquery to request tabular and tree-structured data; and the new features make it convenient and provide performance advantages in retrieving that data as JSON, "said Taras mitran, senior effecect, IVC Inc.

RelatedArticle:

PostgreSQL 9.2 has been released