PostgreSQL 9.6 improves synchronous replication and more
PostgreSQL 9.6 improves synchronous replication and more
Posted Oct 20, 2016 12:09 UTC (Thu) by niner (subscriber, #26151)Parent article: PostgreSQL 9.6 improves synchronous replication and more
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.
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 :)
Posted Oct 21, 2016 20:04 UTC (Fri)
by jberkus (guest, #55561)
[Link]
Mind you, I'm looking forward to Postgres 10 with hot upgrades via logical replication.
PostgreSQL 9.6 improves synchronous replication and more
I think that was an Andrew Dunstan fix. Anyway, very useful.