From: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
---|---|
To: | Richard Neill <rn214(at)cam(dot)ac(dot)uk> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Limited Shared Buffer Problem |
Date: | 2010-01-29 18:18:33 |
Message-ID: | e94e14cd1001291018j33eee8b3y7bcba48c79dc840c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
2010/1/29 Richard Neill <rn214(at)cam(dot)ac(dot)uk>:
>
>
> **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.
AFAIK effective_cache_size is estimation of OS Page Cache + Estimated
Cache in shared_buffers.
>
> 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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Cédric Villemain
From | Date | Subject | |
---|---|---|---|
Next Message | Ing . Marcos Luís Ortíz Valmaseda | 2010-01-29 18:24:12 | Re: Limited Shared Buffer Problem |
Previous Message | jose javier parra sanchez | 2010-01-29 17:46:10 | Re: Limited Shared Buffer Problem |