PostgreSQL 9.2 Is Faster, Packs In Many New Features

[phoronix]

Phoronix: PostgreSQL 9.2 Is Faster, Packs In Many New Features

PostgreSQL 9.2 was released earlier today and presents some mighty impressive performance improvements along with other new features...

http://www.phoronix.com/vr.php?view=MTE4MTQ

[ghexsel]

Benchmark or it didn't happen!

[sagetarian]

would be interesting to see the differences between PostgreSQL and MySQL and comparison benchmarks when possible

[mirza]

I would love to see PostgreSQL vs. MySQL vs. MSSQL vs. Oracle vs. DB2 on one big (>10GB) properly indexed database, doing complicated JOINS and lots of inserts simultaneously. I mean THE Benchmark.

[bug77]

would be interesting to see the differences between PostgreSQL and MySQL and comparison benchmarks when possible

What for? People will just complain that this or that optimization was turned on/off therefore making the test invalid anyway.

[uid313]

Seems like a very very nice release!

The Postgres team have done a great job!

JSON too, cool!

[markg85]

It's very interesting that PostgreSQL can return JSON data directly
For php that doesn't save a lot since json_encode is extremely easy to use.
However, for C++ with QML that does make it very interesting! Now you can just use the PostgreSQL output directly in QML without the need to add a conversion layer in C++. Just to give an example where this could come in handy.