News for hackers. Stuff that matters.
Re:Postgres 9.2 will feature linear read scalability up to 6... by vidarh on Wednesday April 04, 2012 @04:22AM (#3796654)
The big deal for me:

Upgrading Postgres between major versions requires a dump and restore or using upgrade tools, meaning potentially long downtime, unless you set up some really ugly replication solutions.

I have servers I'm upgrading to 9.1 now, from 8.x, and we have wasted lots of time on it on some really hacky solutions because taking the downtime required to do an offline upgrade is just not acceptable.

We'd have paid thousands to avoid that problem, as that's what the time spent on avoiding that downtime is costing us (well, our clients).

Re:Postgres 9.2 will feature linear read scalability up to 6... by j-kidd on Wednesday April 04, 2012 @09:27AM (#3797434)
I think it is fairly reasonable to expect such downtime for major version upgrade. Is there a DBMS vendor that can promise you otherwise?
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.
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.