Open-Source DB PostgreSQL Unveils v9.2

Pete Prestipino — Mon, 10 Sep 2012 18:55:00 GMT

PostgreSQL 9.2 has been released, and the open source database is now poised to drive even greater user adoption for Web, transactional and big data applications.

Thanks to index-only scans, reductions in CPU power consumption and the addition of linear scalability to 64 cores, PostgreSQL 9.2 offers significant improvements in scalability and developer flexibility. Thanks to several improvements in vertical scalability, PostgreSQL has the ability to better utilize hardware resources on larger servers. The results of these recent enhancements/advances are impressive, including up to 350,000 read queries per second making it more than 4X faster, index-only scans for data warehousing queries which are 2–20X faster, and up to 14,000 data writes per second (5X faster).

While PostgreSQL is far from a digital household name, the list of users is quite impressive (and may warrant further exploration). Organizations like the U.S. Federal Aviation Administration and Heroku.com run applications on PostgreSQL, as well as NASA, the Chicago Mercantile Exchange, Instagram and HP, which has adopted it for their remote support software and to power their HP-UX/Itanium solutions.

PostgreSQL 9.0 Released with Built-In Replication

Pete Prestipino — Mon, 20 Sep 2010 20:48:00 GMT

The PostgreSQL Global Development Group announced the release of PostgreSQL 9.0, the latest version of the open source relational database.

PostgreSQL 9.0 includes more than a dozen other major improvements that will enhance every aspect of database application design and performance, including: 64-bit Windows support, conditional and per-column triggers, upgrade-in-place from 8.3 and 8.4, deferrable unique constraints, and high-performance event messaging.

"The built-in replication in 9.0 and ability to query a hot standby have been the most requested PostgreSQL features for many years," said Simon Riggs, CTO of 2ndQuadrant and lead contributor to hot standby. "Efficient, low latency streaming replication protects your data better, while hot standby significantly reduces total cost of ownership. In proprietary products, this capability is an add-on which costs thousands of dollars."

'Net Features : PostgreSQL

Open-Source DB PostgreSQL Unveils v9.2

PostgreSQL 9.0 Released with Built-In Replication