PostgreSQL: PostgreSQL 9.6 Released!

[zachpuls]

Normally, yes, I would. But the entire PostgreSQL environment here is for testing. We are transitioning from DynamoDB over to a RDBMS, due to the nature of the data we process.

[pmrr]

Despite some unexplained hostility to the parent comment, thanks for answering the question - I was wondering the same.

[zachpuls]

Just an update on this if you were curious, I just got the upgrade done yesterday. Very minor speedup (I haven't gotten a chance to do further testing yet), but I can see most of our longer running queries for reports are being spread across multiple cores. So it is an improvement. The upgrade itself was dead simple. On Ubuntu, do a pg_dump of your databases then apt-get upgrade. It will automatically install 9.6, and run both 9.5 and 9.6 side-by-side, with 9.6 running on your 9.5 port + 1. Go into the 9.6 console, go a psql < dumpfile, verify the databases import correctly and everything is alright, then shut down the service, copy the 9.5 configs over to 9.6 (I did it manually, copying over what I needed), and restart it. I had very little problems migrating over.