View Single Post
  #1   (View Single Post)  
Old 15th May 2012
J65nko J65nko is offline
Administrator
 
Join Date: May 2008
Location: Budel - the Netherlands
Posts: 4,131
Default PostgreSQL 9.2 beta improves scalability, adds JSON

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

Quote:
The beta release of version 9.2 of the open source PostgreSQL database has been announced by the PostgreSQL Global Development Group, promising major improvements in performance that enable better horizontal and vertical scalability. One new optimisation – index-only scanning – allows searches to avoid reading the underlying tables and instead search only the indexes; index only scanning happens automatically but there are a number of caveats to its effectiveness. It is claimed though that it will, for most use cases and data warehousing, provide "an order-of-magnitude performance improvement".
__________________
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