pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hervé Piedvache <herve@elma.fr>
To: Jeff <threshar@torgo.978.org>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Thu, 20 Jan 2005 15:54:23 +0100
Message-ID: <200501201554.23462.herve@elma.fr> (raw)
In-Reply-To: <4C477AFA-6AF2-11D9-9D52-000D9366F0C4@torgo.978.org>
References: <200501201503.31241.herve@elma.fr>
	<200501201536.08656.herve@elma.fr>
	<4C477AFA-6AF2-11D9-9D52-000D9366F0C4@torgo.978.org>

Le Jeudi 20 Janvier 2005 15:48, Jeff a écrit :
> On Jan 20, 2005, at 9:36 AM, Hervé Piedvache wrote:
> > Sorry but I don't agree with this ... Slony is a replication solution
> > ... I
> > don't need replication ... what will I do when my database will grow
> > up to 50
> > Gb ... I'll need more than 50 Gb of RAM on each server ???
>
> Slony doesn't use much ram. The mysql clustering product, ndb I believe
> it is called, requires all data fit in RAM. (At least, it used to).
> What you'll need is disk space.

Slony do not use RAM ... but PostgreSQL will need RAM for accessing a database 
of 50 Gb ... so having two servers with the same configuration replicated by 
slony do not slove the problem of the scalability of the database ...

> As for a cluster I think you are thinking of multi-master replication.

No I'm really thinking about a Cluster solution ... having several servers 
making one big virtual server to have several processors, and many RAM in 
many boxes ...

> You should look into what others have said about trying to partiition
> data among several boxes and then join the results together.

??? Who talk about this ?

> Or you could fork over  hundreds of thousands of dollars for Oracle's
> RAC.

No please do not talk about this again ... I'm looking about a PostgreSQL 
solution ... I know RAC ... and I'm not able to pay for a RAC certify 
hardware configuration plus a RAC Licence.

Regards,
-- 
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902



view thread (131+ messages)  latest in thread

Message-ID: <200501201554.23462.herve@elma.fr>
Permalink:  ../200501201554.23462.herve@elma.fr/
Also on:    postgresql.org/message-id/200501201554.23462.herve@elma.fr

 · 

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

* 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