Re:Postgres 9.2 will feature linear read scalability up to 6...
by einhverfr on Wednesday April 04, 2012 @06:12AM
(#3796892)
Look into pg_upgrade.
[ Parent
| on HN ]
Re:Postgres 9.2 will feature linear read scalability up to 6...
by vidarh on Wednesday April 04, 2012 @07:48AM
(#3797101)
It still requires the server to be taken down during the upgrade, and has a bunch of limitations that means it's still more cost effective for us to spend a few days on ugly custom hacks to avoid the pain.
Re:Postgres 9.2 will feature linear read scalability up to 6...
by fdr on Wednesday April 04, 2012 @04:07PM
(#3799578)
The most obvious balm is a logical replication solution. Unfortunately those require non-trivial implementation, but it's something that is in its broad generalities not controversial for inclusion.
Dimitri Fontaine has posted a large patch to implement a devilish component of that, DDL/Command triggers, receiving a lot of detailed review and attention: https://commitfest.postgresql.org/action/patch_view?id=768
But I think a cohesive solution can only be realistically realized in releases >= 9.3.