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 BE1323A48DC for ; Thu, 20 Jan 2005 19:36:00 +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 65650-09 for ; Thu, 20 Jan 2005 19:35:51 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.201]) by svr1.postgresql.org (Postfix) with ESMTP id D5F613A4905 for ; Thu, 20 Jan 2005 19:35:45 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id f1so21677rne for ; Thu, 20 Jan 2005 11:35:44 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=fKJoCV/SZAAQIo/k7GnKvHaXM0K5s6gnj/Q39xejjAYDgerm8f73RleIEEGH5uPZES/G09n7HKPsgQNhtTWUHY3+QLVHq+GLATXUfH72u04UMnC6A1kS5nW3pg3iOhJZ2loVZQ7pwWAoRuj3Jh1w48ftUf2Edn67xNyaH+0cJtA= Received: by 10.38.157.1 with SMTP id f1mr123382rne; Thu, 20 Jan 2005 11:35:44 -0800 (PST) Received: by 10.38.149.21 with HTTP; Thu, 20 Jan 2005 11:35:44 -0800 (PST) Message-ID: <4b09a0c05012011355033781b@mail.gmail.com> Date: Thu, 20 Jan 2005 20:35:44 +0100 From: Jean-Max Reymond Reply-To: Jean-Max Reymond To: Steve Wampler Subject: Re: PostgreSQL clustering VS MySQL clustering Cc: Mitch Pirtle , pgsql-performance@postgresql.org In-Reply-To: <41F002CD.3040900@noao.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <200501201503.31241.herve@elma.fr> <200501201542.06645.herve@elma.fr> <41EFC569.6030800@familyhealth.com.au> <200501200933.42951.darcy@wavefire.com> <330532b6050120104246597d2a@mail.gmail.com> <41F002CD.3040900@noao.edu> 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/338 X-Sequence-Number: 10028 On Thu, 20 Jan 2005 12:13:17 -0700, Steve Wampler wrote: > Mitch Pirtle wrote: > But that's not enough, because you're going to be running separate > postgresql backends on the different hosts, and there are > definitely consistency issues with trying to do that. So far as > I know (right, experts?) postgresql isn't designed with providing > distributed consistency in mind (isn't shared memory used for > consistency, which restricts all the backends to a single host?). yes, you're right: you'll need a Distributed Lock Manager and an application to manage it , Postgres ?