Re: How much ram is too much - Mailing list pgsql-performance

From Dave Cramer
Subject Re: How much ram is too much
Date
Msg-id E32FCBD3-0DD1-463B-AD5F-309E06F815D9@fastcrypt.com
Whole thread Raw
In response to Re: How much ram is too much  (Jim Nasby <decibel@decibel.org>)
Responses Re: How much ram is too much  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-performance
On 10-Jun-07, at 11:11 PM, Jim Nasby wrote:

> On Jun 8, 2007, at 11:31 AM, Dave Cramer wrote:
>> Is it possible that providing 128G of ram is too much ? Will other
>> systems in the server bottleneck ?
>
> Providing to what? PostgreSQL? The OS? My bet is that you'll run
> into issues with how shared_buffers are managed if you actually try
> and set them to anything remotely close to 128GB.

Well, we'd give 25% of it to postgres, and the rest to the OS.

What is it specifically you are referring to ?

Dave
> --
> Jim Nasby                                            jim@nasby.net
> EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Vacuum takes forever
Next
From: Markus Schiltknecht
Date:
Subject: Re: dbt2 NOTPM numbers