pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSetting the shared buffers
2+ messages / 2 participants
[nested] [flat]
* Setting the shared buffers
@ 2006-02-27 12:43 Javier Somoza <jsomoza@pandasoftware.es>
0 siblings, 1 reply; 2+ messages in thread
From: Javier Somoza @ 2006-02-27 12:43 UTC (permalink / raw)
To: pgsql-performance
Hi,
How should i set this configuration? Depending on the
memory?
And then is it necessary to perform a benchmarking test?
What did you do?
Thx!
Javier Somoza
Oficina de Dirección Estratégica
mailto:jsomoza@pandasoftware.es
Panda Software
Buenos Aires, 12
48001 BILBAO - ESPAÑA
Teléfono: 902 24 365 4
Fax: 94 424 46 97
http://www.pandasoftware.es
Panda Software, una de las principales compañías desarrolladoras de
soluciones de protección contra virus e intrusos, presenta su nueva
familia de soluciones. Todos los usuarios de ordenadores, desde las
redes más grandes a los domésticos, disponen ahora de nuevos productos
con excelentes tecnologías de seguridad. Más información en:
http://www.pandasoftware.es/productos
¡Protéjase ahora contra virus e intrusos! Pruebe gratis nuestros
productos en http://www.pandasoftware.es/descargas/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Setting the shared buffers
@ 2006-02-27 13:17 Claus Guttesen <kometen@gmail.com>
parent: Javier Somoza <jsomoza@pandasoftware.es>
0 siblings, 0 replies; 2+ messages in thread
From: Claus Guttesen @ 2006-02-27 13:17 UTC (permalink / raw)
To: Javier Somoza <jsomoza@pandasoftware.es>; +Cc: pgsql-performance
>
> How should i set this configuration? Depending on the memory?
> And then is it necessary to perform a benchmarking test?
I've set it to 'shared_buffers = 12288' with 8 GB RAM on postgresql 7.4.9,
FreeBSD 6.0. There is no exact size, depends on type of workload, server-OS
etc. Adjust it up and down and see if your performance changes.
regards
Claus
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-02-27 13:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-27 12:43 Setting the shared buffers Javier Somoza <jsomoza@pandasoftware.es>
2006-02-27 13:17 ` Claus Guttesen <kometen@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox