X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E02C33A4269 for ; Thu, 20 Jan 2005 14:54:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10081-02 for ; Thu, 20 Jan 2005 14:54:19 +0000 (GMT) Received: from mailer.elma.loc (mail.elma.fr [213.41.14.138]) by svr1.postgresql.org (Postfix) with ESMTP id 4D1E43A47D6 for ; Thu, 20 Jan 2005 14:54:22 +0000 (GMT) Received: from mailer.elma.loc (localhost [127.0.0.1]) by localhost (Postfix) with ESMTP id 6CCAEEC2E4; Thu, 20 Jan 2005 15:55:08 +0100 (CET) Received: from herve.elma.fr (herve.elma.fr [10.0.1.2]) by mailer.elma.loc (Postfix) with ESMTP id 40787EC2BF; Thu, 20 Jan 2005 15:55:08 +0100 (CET) From: =?iso-8859-15?q?Herv=E9_Piedvache?= Organization: Elma =?iso-8859-15?q?Ing=E9nierie?= Informatique To: Jeff Subject: Re: PostgreSQL clustering VS MySQL clustering Date: Thu, 20 Jan 2005 15:54:23 +0100 User-Agent: KMail/1.7.1 Cc: Christopher Kings-Lynne , pgsql-performance@postgresql.org References: <200501201503.31241.herve@elma.fr> <200501201536.08656.herve@elma.fr> <4C477AFA-6AF2-11D9-9D52-000D9366F0C4@torgo.978.org> In-Reply-To: <4C477AFA-6AF2-11D9-9D52-000D9366F0C4@torgo.978.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200501201554.23462.herve@elma.fr> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.098 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/283 X-Sequence-Number: 9973 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