3 ms·
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
by craigkerstiens 14y ago
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.