PostgreSQL 9.2 Out with Greatly Improved Scalability

Posted by Unknown on Monday September 10, 2012 @11:07AM from the rev-your-engines dept.

The PostgreSQL project announced the release of PostgreSQL 9.2 today. The headliner: "With the addition of linear scalability to 64 cores, index-only scans and reductions in CPU power consumption, PostgreSQL 9.2 has significantly improved scalability and developer flexibility for the most demanding workloads. ... Up to 350,000 read queries per second (more than 4X faster) ... Index-only scans for data warehousing queries (2–20X faster) ... Up to 14,000 data writes per second (5X faster)" Additionally, there's now a JSON type (including the ability to retrieve row results in JSON directly from the database) ala the XML type (although lacking a broad set of utility functions). Minor, but probably a welcome relief to those who need them, 9.2 adds range restricted types. For the gory details, see the what's new page, or the full release notes.

2 of 146 comments (clear)

Min score:

Reason:

Sort:

That's great and all, but . . . by Mitchell314 · 2012-09-10 12:19 · Score: 2, Funny

When are they going to come out with the feature where it installs on OS X without requiring a human sacrifice? :P

--
I read TFA and all I got was this lousy cookie
1. Re:That's great and all, but . . . by cas2000 · 2012-09-10 13:40 · Score: 4, Funny
  
  you atheists love to take all the fun out of things, don't you?
  Eliminate the human sacrifice now and next you'll be saying we have to get rid of our Steve Jobs altars.