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.
- 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.