Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1A0399FBF69 for ; Fri, 8 Jun 2007 14:39:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 25260-06 for ; Fri, 8 Jun 2007 14:38:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id B61C89FBF3A for ; Fri, 8 Jun 2007 14:39:07 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l58HbQ0s006755; Fri, 8 Jun 2007 10:37:26 -0700 Message-ID: <4669940F.3050002@commandprompt.com> Date: Fri, 08 Jun 2007 10:38:23 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.10 (X11/20070403) MIME-Version: 1.0 To: david@lang.hm CC: Ben , Dave Cramer , postgresql performance list Subject: Re: How much ram is too much References: <47A154B5-496C-478A-B60D-4238AF12EAC6@fastcrypt.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 08 Jun 2007 10:37:27 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/166 X-Sequence-Number: 25199 david@lang.hm wrote: >> On Fri, 8 Jun 2007, Dave Cramer wrote: >> >>> Is it possible that providing 128G of ram is too much ? Will other >>> systems >>> in the server bottleneck ? > > the only way 128G of ram would be too much is if your total database > size (including indexes) is smaller then this. > > now it may not gain you as much of an advantage going from 64G to 128G > as it does going from 32G to 64G, but that depends on many variables as > others have been asking. I don't know about the IBM but I know some of the HPs require slower ram to actually get to 128G. Joshua D. Drake > > David Lang > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/