Link Details

Link 848171 thumbnail
User 1059809 avatar

By egregory
via architects.dzone.com
Published: Sep 12 2012 / 16:48

With its version 9.2 release, PostgreSQL is gaining long-awaited features like native JSON support, as well as increases to speed and scalability.
  • 21
  • 0
  • 1984
  • 2099

Comments

Add your comment
User 226052 avatar

craig081785 replied ago:

1 votes Vote down Vote up Reply

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.

User 116586 avatar

Jacek replied ago:

0 votes Vote down Vote up Reply

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.

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Apache Hadoop
Written by: Piotr Krewski
Featured Refcardz: Top Refcardz:
  1. Play
  2. Akka
  3. Design Patterns
  4. OO JS
  5. Cont. Delivery
  1. Play
  2. Java Performance
  3. Akka
  4. REST
  5. Java