Advanced

PostgresSQL 9.2 works faster and smarter

Posted by Scott_Ruecker on · Post a comment
Heise
Mail this story
Print this story

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.

Full Story

  Nav
» Read more about: Story Type: News Story

» Get new stories by e-mail: nightly or as they are published

« Return to the newswire homepage

  Related stories
» More like this

Comments

No comments yet. Be the first.

Post a comment

A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.

Your message:
|||||
10
Markdown: **bold**, *italic*, [text](https://link), - lists, > quotes, $x^2$ for math. Formatting help

Sign up and post (it is free)  or  Log in and post