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
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!
11742 NW Valley Vista Rd.
Hillsboro, OR 97124
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
pgsql-performance by date
|Next:||From: Andrew Sullivan||Date: 2002-10-28 20:59:27|
|Subject: Re: Clusters|
|Previous:||From: Lars Maschke||Date: 2002-10-28 11:00:52|
|Subject: [pgsql-performance] Performance Problems|