Link Details

We've been pretty excited about this release to come for some time at Heroku as its loaded with great features. In addition to the JSON datatype here's a bit of a longer list of features that are pretty noteworthy in the release: - Allow libpq connection strings to have the format of a URI - Add a JSON data type - Allow the planner to generate custom plans for specific parameter values even when using prepared statements - Add the SP-GiST (Space-Partitioned GiST) index access method - Add support for range data types - Cancel queries if clients get disconnected - Add CONCURRENTLY option to DROP INDEX - Add a tcn (triggered change notification) module to generate NOTIFY events on table changes - Allow pg_stat_statements to aggregate similar queries via SQL - text normalization. Users with applications that use non-parameterized SQL will now be able to monitor query performance without detailed log analysis.

Oracle, time to get worried. We are already planning to migrate from Oracle/MySQL to PostgreSQL in the next 3-4 months. Moving from Oracle to PgSQL is trivial in most cases.