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 7C51B3A484E for ; Thu, 20 Jan 2005 17:17: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 47830-09 for ; Thu, 20 Jan 2005 17:16:58 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 18EEF3A4805 for ; Thu, 20 Jan 2005 17:16:57 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 04ABE319C2; Thu, 20 Jan 2005 18:16:56 +0100 (MET) From: William Yu X-Newsgroups: pgsql.performance Subject: Re: PostgreSQL clustering VS MySQL clustering Date: Thu, 20 Jan 2005 09:12:01 -0800 Organization: Hub.Org Networking Services Lines: 10 Message-ID: References: <200501201503.31241.herve@elma.fr> <41EFBF05.6000509@familyhealth.com.au> <200501201536.08656.herve@elma.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en In-Reply-To: <200501201536.08656.herve@elma.fr> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/322 X-Sequence-Number: 10012 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 ??? > This solution is not very realistic for me ... Have you confirmed you need a 1:1 RAM:data ratio? Of course more memory gets more speed but often at a diminishing rate of return. Unless every record of your 50GB is used in every query, only the most commonly used elements of your DB needs to be in RAM. This is the very idea of caching.