pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <decibel@decibel.org>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Herv? Piedvache <herve@elma.fr>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Jeff <threshar@torgo.978.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Thu, 20 Jan 2005 19:39:22 -0600
Message-ID: <20050121013922.GM67721@decibel.org> (raw)
In-Reply-To: <41EFCA6A.1080802@commandprompt.com>
References: <200501201503.31241.herve@elma.fr>
	<41EFC722.2050401@familyhealth.com.au>
	<41EFC8B5.9040902@commandprompt.com>
	<200501201607.51659.herve@elma.fr>
	<41EFCA6A.1080802@commandprompt.com>

On Thu, Jan 20, 2005 at 07:12:42AM -0800, Joshua D. Drake wrote:
> 
> >>then I was thinking. Couldn't he use
> >>multiple databases
> >>over multiple servers with dblink?
> >>
> >>It is not exactly how I would want to do it, but it would provide what
> >>he needs I think???
> >>   
> >>
> >
> >Yes seems to be the only solution ... but I'm a little disapointed about 
> >this ... could you explain me why there is not this kind of 
> >functionnality ... it seems to be a real need for big applications no ?
> > 
> >
> Because it is really, really hard to do correctly and hard
> equals expensive.

To expand on what Josh said, the expense in this case is development
resources. If you look on the developer site you'll see a huge TODO list
and a relatively small list of PostgreSQL developers. To develop a
cluster solution similar to RAC would probably take the efforts of the
entire development team for a year or more, during which time very
little else would be done.

I'm glad to see your persistance in wanting to use PostgreSQL, and there
might be some kind of limited clustering scheme that could be
implemented without a great amount of effort by the core developers. In
that case I think there's a good chance you could find people willing to
work on it.
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"



view thread (131+ messages)  latest in thread

Message-ID: <20050121013922.GM67721@decibel.org>
Permalink:  ../20050121013922.GM67721@decibel.org/
Also on:    postgresql.org/message-id/20050121013922.GM67721@decibel.org

 · 

reply

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: decibel@decibel.org, jd@commandprompt.com, herve@elma.fr, chriskl@familyhealth.com.au, threshar@torgo.978.org
  Subject: Re: PostgreSQL clustering VS MySQL clustering
  In-Reply-To: <20050121013922.GM67721@decibel.org>

* 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