The news release doesn't tell me about or link to what's-new. That's here:<p><a href="http://wiki.postgresql.org/wiki/Whats_new_in_PostgreSQL_9.2" rel="nofollow">http://wiki.postgresql.org/wiki/Whats_new_in_PostgreSQL_9.2</a>
A lot of treats in this release! Amongst the new big features (cascaded replication, index only scans) I'm really happy to see a row->json function (great for message queues), DROP INDEX CONCURRENTLY (more flexibility to play with indexes even on production servers), NOT VALID CHECK constraints allowing us to slowly roll out more integrity, and a few other things. Great work as always!
As a Rails user the best feature for me is the improvement of pg_stat_statements to normalize queries: <a href="https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2#pg_stat_statements" rel="nofollow">https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_...</a><p>That means I get a real overview on what Rails is actually doing and what takes the longest.
Try the feature matrix which includes 9.2: <a href="http://www.postgresql.org/about/featurematrix/" rel="nofollow">http://www.postgresql.org/about/featurematrix/</a>
For those wondering what SP-GiST is: it allows the creation of new kinds of specialized non-btree indexes. 9.2 comes with spgist suffix trees over text and spgist quad trees over points.
Excited to see the native JSON datatype. <a href="http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2#JSON_datatype" rel="nofollow">http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9...</a>