Re: general features

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: general features
Date: 2007-06-03 15:47:27
Message-ID: 4662E28F.5000805@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/03/07 09:08, Badawy, Mohamed wrote:
[snip]
>
> Thanks for all of the replies,,,
>
> What I mean by clustering is to put the database on many machines.

Single database on many machines?

Do you mean federation/horizontal scaling, or DR replication or
something different. PostgreSQL has master-slave replication using
Slony-1.

If you mean simultaneous access to the same disks from multiple
machines without corrupting the data, you'll have to go to a
proprietary system. 10K (15K if you've got the scratch) RPM RAID10,
8GB RAM and a couple of dual-core Opterons is a *really* fast
database box. You might not need more than that.

But if you *do* need the continuous uptime that shared-disk
clustering and rolling in-place upgrades gives you, then Rdb/VMS
can't be beat. It'll *cost*, though.

--
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2007-06-03 15:48:51 Re: multimaster
Previous Message Badawy, Mohamed 2007-06-03 14:08:14 Re: general features