On Mar 6, 2007, at 3:42 AM, veejar wrote:
Hi! I have server such configuration: 2 x Xeon LV DualCore 1.66GHz MEM 4Gb DDR2-400 2 x 250Gb SATA HDD
how are you using the drives? software mirror?
I have 20 databases on PostgreSQL 8. 2 of them are more than 1GB. I have ~50 requests per second.
Nice small DB's... :-)
What kernel setting can you recommend me?
in sysctl.conf: # Following for Postgres to use more memory and semaphores # see also kern.ipcs.sem* in /boot/loader.conf kern.ipc.shm_use_phys=1 kern.ipc.shmmax=1073741824 kern.ipc.shmall=262144 kern.ipc.semmsl=512 kern.ipc.semmap=256 in loader.conf: # IPC settings for big postgres # see also /etc/sysctl.conf for other kern.ipc settings kern.ipc.semmni=32 kern.ipc.semmns=512But your most bang for the buck will be optimizing your postgresql.conf file. This is a black art :-( and takes much experimentation.
I'm considering increasing SHMMAX and SHMALL given recent postgres developments, and having more than 4Gb of RAM on some of my servers... But it suits me so far.
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
