View Single Post
  #1   (View Single Post)  
Old 11th September 2012
J65nko J65nko is offline
Administrator
 
Join Date: May 2008
Location: Budel - the Netherlands
Posts: 4,131
Default PostgresSQL 9.2 works faster and smarter

From http://h-online.com/-1703901

Quote:
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.
__________________
You don't need to be a genius to debug a pf.conf firewall ruleset, you just need the guts to run tcpdump
Reply With Quote