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 CBC763A48AD for ; Thu, 20 Jan 2005 18:09:05 +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 53330-06 for ; Thu, 20 Jan 2005 18:08:56 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by svr1.postgresql.org (Postfix) with ESMTP id 7F31B3A47E8 for ; Thu, 20 Jan 2005 18:08:55 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 67so23217wri for ; Thu, 20 Jan 2005 10:08:55 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:cc:subject:date:organization:message-id:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:in-reply-to:x-mimeole:importance; b=T+kVoUW1xa06OWcJVHY9NBOYKV851kxbHmlD9CSZF1y/y2Ndk9xUv9QMtxPJAj6sdfCJPPeyItdfCLnvbYSl27drtq+aquHFX9QNb+ygPe0t03HzsfgO4HjAia9MpQSHIX6yo0MnqsqzlqmCpJbEwFeFe2tLQViEO1ssqIUHm9o= Received: by 10.54.14.79 with SMTP id 79mr142235wrn; Thu, 20 Jan 2005 10:08:55 -0800 (PST) Received: from sbew318anc22 ([200.184.93.96]) by smtp.gmail.com with ESMTP id 33sm3968wra.2005.01.20.10.08.53; Thu, 20 Jan 2005 10:08:55 -0800 (PST) From: "Bruno Almeida do Lago" To: =?iso-8859-1?Q?'Herv=E9_Piedvache'?= Cc: Subject: Re: PostgreSQL clustering VS MySQL clustering Date: Thu, 20 Jan 2005 16:09:57 -0200 Organization: G&P Message-ID: <005701c4ff1b$42c0ada0$e883f40a@br.gedasgrp> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <200501201631.07053.herve@elma.fr> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/330 X-Sequence-Number: 10020 Could you explain us what do you have in mind for that solution? I mean, forget the PostgreSQL (or any other database) restrictions and explain = us how this hardware would be. Where the data would be stored? I've something in mind for you, but first I need to understand your = needs! C ya. Bruno Almeida do Lago =20 -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Herv=E9 = Piedvache Sent: Thursday, January 20, 2005 1:31 PM To: Merlin Moncure Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] PostgreSQL clustering VS MySQL clustering Le Jeudi 20 Janvier 2005 16:16, Merlin Moncure a =E9crit : > > 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. > > Are you totally certain you can't solve your problem with a single = server > solution? > > How about: > Price out a 4 way Opteron 4u rackmount server with 64 bit linux, = stuffed > with hard drives (like 40) set up in a complex raid configuration (multiple > raid controllers) allowing you (with tablespaces) to divide up your > database. > > You can drop in dual core opterons at some later point for an easy upgrade. > Let's say this server costs 20k$...are you sure this will not be = enough to > handle your load? I'm not as I said ibn my mail I want to do a Cluster of servers ... :o) --=20 Herv=E9 Piedvache Elma Ing=E9nierie Informatique 6 rue du Faubourg Saint-Honor=E9 F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster