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 7E6783A47B7 for ; Thu, 20 Jan 2005 18:42:38 +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 56150-01 for ; Thu, 20 Jan 2005 18:42:26 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.197]) by svr1.postgresql.org (Postfix) with ESMTP id EEF063A18CF for ; Thu, 20 Jan 2005 18:42:26 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 63so106250wri for ; Thu, 20 Jan 2005 10:42:25 -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:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=Zedz3jgl/uU+lMsq746kNimo+zmPA4nutk5OYFTns4Fjd3rIBMeb5+DcleTgPpc6buBImlWIEMhBCOg7eeCQC2R8JbvhrfxvUzyCJolGKqAwWVIxUBhiWjU2EF3lb4jzTlmEygFP4HkvpZNiCEE8zI277tlz9rMtOHW35SWMAQY= Received: by 10.54.17.37 with SMTP id 37mr172075wrq; Thu, 20 Jan 2005 10:42:25 -0800 (PST) Received: by 10.54.59.22 with HTTP; Thu, 20 Jan 2005 10:42:25 -0800 (PST) Message-ID: <330532b6050120104246597d2a@mail.gmail.com> Date: Thu, 20 Jan 2005 13:42:25 -0500 From: Mitch Pirtle Reply-To: Mitch Pirtle To: pgsql-performance@postgresql.org Subject: Re: PostgreSQL clustering VS MySQL clustering In-Reply-To: <200501200933.42951.darcy@wavefire.com> 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> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.046 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/331 X-Sequence-Number: 10021 On Thu, 20 Jan 2005 09:33:42 -0800, Darcy Buskermolen wrote: > > Another Option to consider would be pgmemcache. that way you just build the > farm out of lots of large memory, diskless boxes for keeping the whole > database in memory in the whole cluster. More information on it can be found > at: http://people.freebsd.org/~seanc/pgmemcache/ Which brings up another question: why not just cluster at the hardware layer? Get an external fiberchannel array, and cluster a bunch of dual Opterons, all sharing that storage. In that sense you would be getting one big PostgreSQL 'image' running across all of the servers. Or is that idea too 90's? ;-) -- Mitch