Skip site navigation (1) Skip section navigation (2)


From: James Kelty <j_kelty(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Clusters
Date: 2002-10-28 20:47:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

I have a question regarding clusters. What with all
the hoop-la about Oracle RAC, the question of
clustering PostgreSQL has come up at work.

Now, I know that only one system can actually update
the database, and in a active/passive failover
situation that is ok. But! If I have lots and lots of
READS from the DB, can I cluster many low end systems
together behind an SLB? Assume that all systems have a
qlogic card, and are attached to a SAN, and that the
SAN holds the data. Can PostgreSQL be configured to
read from the SAN? Does each system have to initialize
the DB?

I think this could greatly improve the perfomance from
a application appearance, but, so far I have only seen
documentation about Oracle RAC, DB2, and MySQL using
some sort of cluster software, be it, kimberlite, Red
Hat Cluster Manager, or Vertias Cluster Server.

PostgreSQL seems to be our DB of choice, and I just
want to have a scalable solution via clustering for
it. No replication. Thanks for any thoughts!


James Kelty
11742 NW Valley Vista Rd.
Hillsboro, OR 97124
Cell: 541.621.5832

Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site


pgsql-performance by date

Next:From: Andrew SullivanDate: 2002-10-28 20:59:27
Subject: Re: Clusters
Previous:From: Lars MaschkeDate: 2002-10-28 11:00:52
Subject: [pgsql-performance] Performance Problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group