Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E7D9F9FB5D5 for ; Mon, 11 Jun 2007 14:59:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15903-04 for ; Mon, 11 Jun 2007 14:59:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from beaver.fastcrypt.com (beaver.fastcrypt.com [64.7.141.17]) by postgresql.org (Postfix) with ESMTP id 9879A9FB872 for ; Mon, 11 Jun 2007 14:59:07 -0300 (ADT) Received: from [192.168.1.14] (dcdsl.ebox.com [64.7.143.116]) by beaver.fastcrypt.com (Postfix) with ESMTP id 4D9391580683 for ; Mon, 11 Jun 2007 14:09:32 -0400 (EDT) Mime-Version: 1.0 (Apple Message framework v752.3) In-Reply-To: <20070611153414.GK24327@phlogiston.dyndns.org> References: <47A154B5-496C-478A-B60D-4238AF12EAC6@fastcrypt.com> <20070611153414.GK24327@phlogiston.dyndns.org> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <90889DC6-FA91-4968-8617-29E215082088@fastcrypt.com> Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: How much ram is too much Date: Mon, 11 Jun 2007 13:59:08 -0400 To: postgresql performance list X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/196 X-Sequence-Number: 25229 Hi Andrew On 11-Jun-07, at 11:34 AM, Andrew Sullivan wrote: > On Mon, Jun 11, 2007 at 11:09:42AM -0400, Dave Cramer wrote: >>> and set them to anything remotely close to 128GB. >> >> Well, we'd give 25% of it to postgres, and the rest to the OS. > > Are you quite sure that PostgreSQL's management of the buffers is > efficient with such a large one? No, I'm not sure of this. > In the past, that wasn't the case > for relatively small buffers; with the replacement of single-pass > LRU, that has certainly changed, but I'd be surprised if anyone > tested a buffer as large as 32G. So does anyone have experience above 32G ? Dave > > A > > -- Andrew Sullivan | ajs@crankycanuck.ca > The whole tendency of modern prose is away from concreteness. > --George Orwell > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate