Re: New Opteron box, dedicated to PostgreSQL

Am 16.03.2007 um 12:17 schrieb Claus Guttesen:

>
> /boot/loader.conf:
>
> kern.ipc.semmni=256
> kern.ipc.semmns=2048
>
>
> /etc/sysctl.conf:
>

> kern.ipc.somaxconn=2048
This one is new to me.
>
> # Suggestions by Vivek Khera from postgresql performance
> kern.ipc.shm_use_phys=1
> kern.ipc.shmmax=1073741824
> kern.ipc.shmall=262144
> kern.ipc.semmsl=512
> kern.ipc.semmap=256
>
>
> This is on a four-way woodcrest at 3 GHz and 16 GB ram so you may want
> to adjust the values.

Thank you for this valuable info. I will use it as a starting point.

Regards, Axel
---------------------------------------------------------------------
Axel Rau, ☀Frankfurt , Germany                       +49 69 9514 18 0