From: | Richard Neill <rn214(at)cam(dot)ac(dot)uk> |
---|---|
To: | |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Limited Shared Buffer Problem |
Date: | 2010-01-29 16:53:01 |
Message-ID: | 4B63126D.5080303@cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
**Rod MacNeil wrote:
> Hi All,
>
> I have a server running CentOS5 with 6gb of memory that will run
> postgres 8.3 exclusively.
> I would like to allocate 4gb of the memory to shared buffers for postgres.
It might be worth pausing at this point:
The various postgresql tuning guides usually suggest that on a dedicated
system, you should give postgres about 1/4 of the RAM for shared
buffers, while telling it that the effective_cache_size = 1/2 RAM.
Postgres will make good use of the OS cache as a file-cache - the
"effective_cache_size" setting is advisory to postgres that it can
expect about this much data to be in RAM.
Also, If you are setting up a new system, it's probably worth going for
8.4.2. Postgres is relatively easy to build from source.
HTH,
Richard
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-01-29 17:18:15 | Re: Limited Shared Buffer Problem |
Previous Message | **Rod MacNeil | 2010-01-29 16:37:55 | Limited Shared Buffer Problem |