Re: two postgres server seeing the same data

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: two postgres server seeing the same data
Date: 2008-12-03 21:43:31
Message-ID: dcc563d10812031343g630a1be2h8244055ce104c4c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 3, 2008 at 2:41 PM, Jaime Casanova
<jcasanov(at)systemguards(dot)com(dot)ec> wrote:
> ok... actually i see no real value in that config (create a single
> point of contention) but everyone that has used (or at least read
> about) oracle think is the best thing to do...

Having dealth with RAC, I can safely say that the application points
for such a cluster are really pretty narrow, and often it's far
cheaper and easier to solve such a problem by just buying a bigger
pair of servers and replicating them than to use the shared storage
method. I've seen plenty of problems with RAC, especially on linux,
having much worse performance than the two big server setup.

Plus, given the cost of Oracle RAC licenses, you can build a couple of
pretty farking huge pg servers.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-12-03 21:49:53 Re: two postgres server seeing the same data
Previous Message Jaime Casanova 2008-12-03 21:41:40 Re: two postgres server seeing the same data