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
-------------------------------------------
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
