Re: Hot Standby (v9d) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Hot Standby (v9d)
Date
Msg-id 603c8f070901281258k5b9b29cas5d38f2a245d20968@mail.gmail.com
Whole thread Raw
In response to Re: Hot Standby (v9d)  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Hot Standby (v9d)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>> I don't. Primarily, we must support high availability. It is much better
>> if we get people saying "I get my queries cancelled" and we say RTFM and
>> change parameter X, than if people say "my failover was 12 hours behind
>> when I needed it to be 10 seconds behind and I lost a $1 million because
>> of downtime of Postgres" and we say RTFM and change parameter X.
>
> If the person was stupid enough to configure it for such as thing they
> deserve to the lose the money. Not to mention we have already lost them
> as a user because they will blame postgresql regardless of reality as
> evidenced by their inability to RTFM (or have a vendor that RTFMs) in
> the first place.
>
> I got to vote with Greg on this one.

I vote with Simon.  The thing is that if you get some queries
cancelled, you'll realize you have a problem.  Now you have several
options for what to do to fix it.   Having your failover be 12 hours
behind (or 12 months behind) is something that it would be much easier
to not realize.

...Robert


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to get SE-PostgreSQL acceptable
Next
From: Dimitri Fontaine
Date:
Subject: Re: How to get SE-PostgreSQL acceptable