On Mon, Jun 15, 2009 at 8:42 PM, Iñigo Martinez Lasala <imartinez@xxxxxxxxxxxx> wrote:
Thank you very much, Tom.
We have increased shared buffers to 2.5GB (linux kernels allows us reach this level) and lowered work_mem to 500MB.
Let's see tonight. :-)
If you want to increase shared buffers beyond this value, you should look at increasing shmmax in sysctl.conf.
Best regards,
--
Lets call it Postgres
EnterpriseDB http://www.enterprisedb.com
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
Mail sent from my BlackLaptop device