PostgreSQL 9.2 Out with Greatly Improved Scalability

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.

Comments

/. Poll

[Anonymous Coward]

If you're sitting alone in your cube, and you suddenly smell a horrible fecal smell, you should:
A) Loudly blame the lady in the next cube over to divert attention from yourself
B) Go to the bathroom to check your underwear for unexpected deposits
C) Just get up and leave for 5 minutes to let the dissipate
D) Spray some air freshener around and keep coding

Re:/. Poll

[HornWumpus]

Go home and 'arm' yourself with kim-chi, hard boiled almost expired eggs, beans, brown rice, onions and cheap beer. And milk and cheese if you are lactose intolerant.

'They' started it, it's your job to finish it.