3 ms·
Another year, another awesome release. Thank you so much, PostgreSQL team! As always, there's one feature that makes me want to upgrade immediately. This time
by pilif 13y ago
Another year, another awesome release.
Thank you so much, PostgreSQL team!
As always, there's one feature that makes me want to upgrade immediately. This time it's the NO KEY UPDATE lock mode which will greatly improve the performance of our main application during its lengthy importer runs.
Using pg_upgrade, switching major releases has become something comparably simple to do over the last years, though after last years issues in 9.2.0 (some IN() queries didn't return the correct results), I'm inclined to wait for 9.3.1 this time around.
- craigkerstiens 13y agoFully agreed, a very awesome release and the list of features is in no short supply with this version. Of note: * The improvements to foreign data wrappers to allow them to be writeable along with the Postgres FDW will improve visibility for the functionality * Lateral joins * Materialized views * The checksums for checking against corruption We've elaborated some of our favorites over at Heroku Postgres - https://postgres.heroku.com/blog/past/2013/9/9/postgres_93_now_available/ https://postgres.heroku.com/blog/past/2013/9/9/postgres_93_n... along with how you can provision a 9.3 on us to begin using it right away, and then of course you can always see the full whats new on the wiki http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.3 http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.3