From: Jim Nasby <jnasby@pervasive.com>
To: Jeremy Haile <jhaile@fastmail.fm>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres and Ingres R3 / SAN
Date: Wed, 8 Mar 2006 13:24:17 -0600
Message-ID: <4D27CB1096EF1C408F4BFAB0046EC7B6099E48@ausmailid.aus.pervasive.com> (raw)
Adding -performance back; you should do a reply-all if you want to reply to list messages.
> From: Jeremy Haile [mailto:jhaile@fastmail.fm]
> > Can you point us at more info about this? I can't even find
> a website
> > for Ingres...
>
> Ingres is based off of the same original codebase that PostgreSQL was
> based upon (a long time ago) It is owned by Computer
> Associates and was
> open sourced last year. It supports clustering and replication, and
> I've seen an Ingres install set up as a cluster backed by a
> SAN before.
> I just haven't talked to anyone (at least unbiased) who has used this
> type of setup in production, and I'm not fully aware of the
> advantages/disadvantages of this type of setup with Ingres.
> Since this
> group seems pretty knowledgable about performance advantages
> (and we are
> currently running PostgreSQL), I wanted to see if there were any
> experiences or opinions.
>
> Here is a link to their website:
> http://opensource.ca.com/projects/ingres
>
>
> > Perhaps if you posted your performance requirements someone
> could help
> > point you to a solution that would meet them.
>
> This is honestly more of a curiousity question at the moment,
> so I don't
> have any specific numbers. We definitely have a requirement for
> failover in the case of a machine failure, so we at least need
> Master->Slave replication. However, I wanted to solicit
> information on
> clustering alternatives as well, since scalability will likely be a
> future problem for our database.
Ahh, ok... that's likely a much different requirement than true clustering.
What a lot of folks do right now is segregate their application into a read-only stream and the more interactive read-write streams, and then use Slony to replicate data to a number of machines for the read-only work. This way anyone who's hitting the site read-only (and can handle some possible delay) will just hit one of the slave machines. People who are doing interactive work (updating data) will hit the master. Since most applications do far more reading than they do writing, this is a pretty good way to load-balance.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: jnasby@pervasive.com, jhaile@fastmail.fm
Subject: Re: Postgres and Ingres R3 / SAN
In-Reply-To: <4D27CB1096EF1C408F4BFAB0046EC7B6099E48@ausmailid.aus.pervasive.com>
References: <4D27CB1096EF1C408F4BFAB0046EC7B6099E48@ausmailid.aus.pervasive.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