Re: Limited Shared Buffer Problem - Mailing list pgsql-performance

From Ing . Marcos Luís Ortíz Valmaseda
Subject Re: Limited Shared Buffer Problem
Date
Msg-id 4B6327CC.7070909@uci.cu
Whole thread Raw
In response to Re: Limited Shared Buffer Problem  (Richard Neill <rn214@cam.ac.uk>)
List pgsql-performance
Richard Neill escribió:
>
>
> **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
>
All these values has to be combined with the others: shared_buffers,
work_mem,etc.
My recommendation is to go down a little the shmmax and the
shared_buffers values.
Is very necessary that you have these values so high?

Regards


--
-------------------------------------
"TIP 4: No hagas 'kill -9' a postmaster"
Ing. Marcos Luís Ortíz Valmaseda
PostgreSQL System DBA && DWH -- BI Apprentice

Centro de Tecnologías de Almacenamiento y Análisis de Datos (CENTALAD)
Universidad de las Ciencias Informáticas

Linux User # 418229

-- PostgreSQL --

http://www.postgresql-es.org
http://www.postgresql.org
http://www.planetpostgresql.org

-- DWH + BI --

http://www.tdwi.org

-------------------------------------------


pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Limited Shared Buffer Problem
Next
From: jose javier parra sanchez
Date:
Subject: Re: Limited Shared Buffer Problem