"Postgres has always done very well on personal computers, but with 9.2 it will run very nicely on very large servers," said Tom Kincaid, director of global services for EnterpriseDB. EnterpriseDB, which offers a commercially supported version of Postgres, is a major contributor to the continued development of Postgres, also commonly referred to as PostgreSQL. "It will be in places it hasn't been before."

Perhaps most notably, can now run as a single instance across 64 processor cores, a big bump from the previous official limit of 16 cores in version 9.1. The new version can also write and read the data much more quickly than before.

In addition to being more friendly to the enterprise, the database software also comes with a number of new features to make it more appealing to NoSQL users. Over the past few years, have gained popularity as an alternative to traditional relational databases, such as Postgres, for simple but speedy data storage.

PostgreSQL 9.2 allows access to data through the JSON (JavaScript Object Notation) data exchange format. With the native support of JSON, Web application developers can use Postgres like a NoSQL document key-value store, using familiar tools such as jQuery and PL/V8 JavaScript to fetch and store data. The database management software will store data in the JSON format. It will also validate that the input of JSON string is in the correct form.

As for performance, Postgres can now respond to as many as 350,000 read queries per second, four times as many as previous versions, according to the software's developers. It can perform up to 14,000 writes per second, five times as many as before. The new can speed queries by as much as 20 times, according to the Postgres development team. "The benefit you get from the index will be far greater with 9.2," Kincaid said.