Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 68E55635682
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 22 Jul 2010 17:45:26 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 81344-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 22 Jul 2010 20:45:18 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from n5.bullet.mail.gq1.yahoo.com (n5.bullet.mail.gq1.yahoo.com
	[67.195.9.85])
	by mail.postgresql.org (Postfix) with SMTP id E04706322E8
	for <pgsql-admin@postgresql.org>; Thu, 22 Jul 2010 17:45:18 -0300 (ADT)
Received: from [67.195.9.83] by n5.bullet.mail.gq1.yahoo.com with NNFMP;
	22 Jul 2010 20:45:17 -0000
Received: from [98.137.27.215] by t3.bullet.mail.gq1.yahoo.com with NNFMP;
	22 Jul 2010 20:45:17 -0000
Received: from [127.0.0.1] by omp125.mail.gq1.yahoo.com with NNFMP;
	22 Jul 2010 20:45:17 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 176642.64831.bm@omp125.mail.gq1.yahoo.com
Received: (qmail 10918 invoked by uid 60001); 22 Jul 2010 20:45:16 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1279831516; bh=zKu1imIZVfrKYOuOXy8mquIxRQ5sxKNx+mAsXq6CLrY=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=BLFjzwvymlfHIOcxufsmLGlhCZyOHhwM058VmB+DVQnX3hycezYA4lTEcgwrRFJ6Z16/rn7ZoVO+vHXTsgRb7QBd6CKLABjC35hDdf6RZyPoWTSXrGMA3anR4ly/YSiq5bK4oEWqCmhyBul0RsIRqeqJqq+q9O7myi+O/iwAKsI=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=CorMRopI0rqHYtDJfH+4QlGs8osxaPVSDc9v5EFZ8lhYMahWInKSgWVtMm57W/ZsDpJrQdpXoC19bWSRDTmmovuLsfovYC1vmPnO+Zx3uOwBu44DYW/TU6ZKOjH+t6muS5BGxrZgMPuvL2rjr7KfG0a2oCYbL5z8QpT2zSRZnEA=;
Message-ID: <819397.8724.qm@web120007.mail.ne1.yahoo.com>
X-YMail-OSG: XRfIFLsVM1l6KOEiWWsLDdkuT6ttthyhnickJ_alEB9Fdrw
	cmXiFhZXvbHGoR51MbetSpQ.JUMFpLf09NA7InqIJHAFod0Wb0vpUDs.y7p5
	L9CP4ZymyoDS3oIKD53fXzQcKRm7KBYmLLlBM1beK7wsiiKwh.7csx6Ofw6w
	90X8lN9WtZHwi7tyu43dtIg6Uk.Kqurn41yK54q53BiWsVCl9A6amhd9moaJ
	.XrM03VnrmtW5GRTJpl2iUrpEAHBMOJYyXiEeBwDmZ.TV.O3FtcxNbYEgzs3
	aYh_DISCCPDV1Btk0aZj0HcIDNhCbvdz.VhJRvotctypFGhpRGJr0tjtMQuP
	kBiAKnDlAJh_xUSx0epKgtuMUFOAxFAkVgMXOHHrB_wQfzArJADHGsTDPejV
	rWP48Pu2nTWtq.KrvRdWclkn3tegDvAcQnP4w
Received: from [129.44.63.215] by web120007.mail.ne1.yahoo.com via HTTP;
	Thu, 22 Jul 2010 13:45:16 PDT
X-Mailer: YahooMailRC/420.4 YahooMailWebService/0.8.105.277674
Date: Thu, 22 Jul 2010 13:45:16 -0700 (PDT)
From: A J <s5aly@yahoo.com>
Subject: How much RAM is too much ?
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-98299890-1279831516=:8724"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.791 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201007/159
X-Sequence-Number: 35178

--0-98299890-1279831516=:8724
Content-Type: text/plain; charset=us-ascii

Cost aside, are there any technical factors to consider before increasing RAM 
(assuming the system can support it) ? Is there a sweet spot beyond which more 
RAM does not help Postgres or actually harms ?

If my database is only couple of hundred Gigs, can I not just have RAM that big 
and have read from buffer all the time ?

Thank you !
-AJ


      
--0-98299890-1279831516=:8724
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div><span class="Apple-style-span" style="font-family: Verdana; font-size: 13px; ">Cost aside, are there any technical factors to consider before increasing RAM (assuming the system can support it) ? Is there a sweet spot beyond which more RAM does not help Postgres or actually harms ?<div style="text-indent: 0in !important; "><br style="text-indent: 0in !important; "></div><div style="text-indent: 0in !important; ">If my database is only couple of hundred Gigs, can I not just have RAM that big and have read from buffer all the time ?</div><div style="text-indent: 0in !important; "><br style="text-indent: 0in !important; "></div><div style="text-indent: 0in !important; ">Thank you !</div><div style="text-indent: 0in !important; ">-AJ</div></span></div><div style="position:fixed"></div>


</div><br>







      </body></html>
--0-98299890-1279831516=:8724--