From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | tgutierrez(at)unipamplona(dot)edu(dot)co |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Postgres tiene alguna recomendacion para la variable SHMMAX |
Date: | 2004-08-17 21:49:30 |
Message-ID: | 20040817214930.GA4747@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
On Tue, Aug 17, 2004 at 11:37:57AM -0500, tgutierrez(at)unipamplona(dot)edu(dot)co wrote:
> 1. Increase the buffer size. Postgres uses a shared memory segment among
> its subthreads to buffer data in memory. The default is 512k, which is
> inadequate. On many of our installs, we've bumped it to ~16M, which is
> still small. If you can spare enough memory to fit your whole database in
> memory, do so. Each buffer is 8 kb, so set it to:
> [...]
> este tamaño de la base de datos a que se referira en esta parte.
Al taman~o fisico que la BD ocupa en disco.
Te recomiendo que hagas un programa que use la BD como tu aplicacion
real, y lo pruebes con distintos valores de shared_buffers. Esa es la
unica manera de saber realmente cual es un buen valor para esa variable.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2004-08-17 21:53:00 | Re: Tansac |
Previous Message | Jaime Casanova | 2004-08-17 21:40:34 | Re: Evaluando Postgresql 8 para win32 |