LWN: Comments on "PostgreSQL 9.6 improves synchronous replication and more"

PostgreSQL 9.6 improves synchronous replication and more

jberkus — Fri, 21 Oct 2016 20:04:25 +0000

I think that was an Andrew Dunstan fix. Anyway, very useful.

Mind you, I'm looking forward to Postgres 10 with hot upgrades via logical replication.

PostgreSQL 9.6 improves synchronous replication and more

niner — Thu, 20 Oct 2016 12:09:02 +0000

Something that won't benefit many users but makes me extremely happy:
9.4 contains fixes that make a pg_upgrade much, much, much faster when you have lots of relations. This means that with ~ 150K tables and views a pg_upgrade won't die anymore due to running out of RAM (only 32 GiB available) after several hours, but instead will finish after about 20 minutes with at most 8 GiB RAM used during the process.

This means we can now upgrade to 9.6 at almost any time :)

PostgreSQL 9.6 improves synchronous replication and more

Darkmere — Thu, 20 Oct 2016 10:48:12 +0000

Thank you for the update, appreciated reading.