From: Jeremy Haile <jhaile@fastmail.fm>
To: pgsql-performance@postgresql.org
Subject: Postgres and Ingres R3 / SAN
Date: Mon, 06 Mar 2006 14:58:32 -0500
Message-ID: <1141675112.28202.255960101@webmail.messagingengine.com> (raw)
In-Reply-To: <f3c0b4080603061145y61fe3298n101ff51d0fcabcba@mail.gmail.com>
References: <b2990fb00603060528w634580d3rd3ac3d7f21134e52@mail.gmail.com>
<f3c0b4080603060656l69bcd619nad204bfcf96c68b4@mail.gmail.com>
<20060306131355.A1227@ganymede.hub.org>
<f3c0b4080603061145y61fe3298n101ff51d0fcabcba@mail.gmail.com>
Clustering solutions for PostgreSQL are currently pretty limited. Slony
could be a good option in the future, but it currently only supports
Master-Slave replication (not true clustering) and in my experience is a
pain to set up and administer. Bizgres MPP has a lot of promise,
especially for data warehouses, but it currently doesn't have the best
OLTP database performance.
So, I had a couple of questions:
1) I have heard bad things from people on this list regarding SANs - but
is there a better alternative for a high performance database cluster?
(both for redundancy and performance) I've heard internal storage
touted before, but then you have to do something like master-master
replication to get horizontal scalability and write performance will
suffer.
2) Has anyone on this list had experience using Ingres R3 in a clustered
environment? I am considering using Ingres R3's built-in clustering
support with a SAN, but am interested to know other people's experiences
before we start toying with this possibility. Any experience with the
Ingres support from Computer Associates? Good/bad?
Jeremy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jhaile@fastmail.fm
Subject: Re: Postgres and Ingres R3 / SAN
In-Reply-To: <1141675112.28202.255960101@webmail.messagingengine.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox