Published at LXer:

The new release of PostgreSQL, version 9.2, has arrived, four months after the appearance of the first beta version. The new release includes read and write performance boosts, index-only scanning, new web-oriented functionality, and support for range data types. As shown in the beta, the new version promises to be much faster than its predecessor primarily thanks to index-only scanning, which allows searches to avoid reading the underlying tables and instead search only indexes. This new feature is used automatically, though there are caveats as to how effective it can be all situations, but where the required data is already indexed, for example in "big data" scenarios, the boost in performance can be huge.

Read More...