> 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.
In response to
pgsql-performance by date
|Next:||From: Csaba Nagy||Date: 2006-02-27 13:31:33|
|Subject: neverending vacuum|
|Previous:||From: Javier Somoza||Date: 2006-02-27 12:43:36|
|Subject: Setting the shared buffers|