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 0A4293A6321 for ; Fri, 28 Jan 2005 15:33:15 +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 63045-08 for ; Fri, 28 Jan 2005 15:33:07 +0000 (GMT) Received: from smtp104.rog.mail.re2.yahoo.com (smtp104.rog.mail.re2.yahoo.com [206.190.36.82]) by svr1.postgresql.org (Postfix) with SMTP id EDA753A62F2 for ; Fri, 28 Jan 2005 15:33:06 +0000 (GMT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@216.75.167.195 with login) by smtp104.rog.mail.re2.yahoo.com with SMTP; 28 Jan 2005 15:33:04 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id DD9A93F9C; Fri, 28 Jan 2005 10:33:03 -0500 (EST) Date: Fri, 28 Jan 2005 10:33:03 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: PostgreSQL clustering VS MySQL clustering Message-ID: <20050128153303.GC9076@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: <200501201503.31241.herve@elma.fr> <200501201536.08656.herve@elma.fr> <4C477AFA-6AF2-11D9-9D52-000D9366F0C4@torgo.978.org> <200501201554.23462.herve@elma.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200501201554.23462.herve@elma.fr> User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.032 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/572 X-Sequence-Number: 10262 On Thu, Jan 20, 2005 at 03:54:23PM +0100, Hervé Piedvache wrote: > 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 ... You could use SSD for your storage. That'd make it go rather quickly even if it had to seek on disk. A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner