Kernel Resources Solved - Mailing list pgsql-performance

Problem sovled by setting:

kern.ipc.semmni: 280
kern.ipc.semmns: 300

Chris.


> Mark Kirkwood wrote:
>
>> Chris Hebrard wrote:
>>
>>> kern.ipc.shmmax and kern.ipc.shmmin will not stay to what I set them
>>> to.
>>>
>>> What am I doing wrong or not doing at all?
>>>
>>
>> These need to go in /etc/sysctl.conf. You might need to set shmall as
>> well.
>>
>> (This not-very-clear distinction between what is sysctl'abe and what
>> is a kernel tunable is a bit of a downer).
>>
>> cheers
>>
>> Mark
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>>
>>
>>
>> kern.ipc.maxsockbuf: 8388608
>> kern.ipc.sockbuf_waste_factor: 8
>> kern.ipc.somaxconn: 1024
>> kern.ipc.max_linkhdr: 16
>> kern.ipc.max_protohdr: 60
>> kern.ipc.max_hdr: 76
>> kern.ipc.max_datalen: 136
>> kern.ipc.nmbclusters: 65536
>> kern.ipc.msgmax: 16384
>> kern.ipc.msgmni: 40
>> kern.ipc.msgmnb: 2048
>> kern.ipc.msgtql: 40
>> kern.ipc.msgssz: 8
>> kern.ipc.msgseg: 2048
>> kern.ipc.semmap: 30
>> kern.ipc.semmni: 256
>> kern.ipc.semmns: 272
>> kern.ipc.semmnu: 30
>> kern.ipc.semmsl: 60
>> kern.ipc.semopm: 100
>> kern.ipc.semume: 10
>> kern.ipc.semusz: 92
>> kern.ipc.semvmx: 32767
>> kern.ipc.semaem: 16384
>> kern.ipc.shmmax: 66099200
>> kern.ipc.shmmin: 256
>> kern.ipc.shmmni: 192
>> kern.ipc.shmseg: 128
>> kern.ipc.shmall: 8192
>> kern.ipc.shm_use_phys: 0
>> kern.ipc.shm_allow_removed: 0
>> kern.ipc.mbuf_wait: 32
>> kern.ipc.mbtypes: 37 552 3 0 0 0 0 0 0 0 0 0 0 0 0 0
>> kern.ipc.nmbufs: 262144
>> kern.ipc.nsfbufs: 8704
>> kern.ipc.nsfbufspeak: 4
>> kern.ipc.nsfbufsused: 0
>> kern.ipc.m_clreflimithits: 0
>> kern.ipc.mcl_pool_max: 0
>> kern.ipc.mcl_pool_now: 0
>> kern.ipc.maxsockets: 65536
>
>
> I've got the values to what I want them to be now, after loading some
> values in loader.conf and others in sysctl.conf.
>
> loader.conf:
>
> userconfig_script_load="YES"
> kern.ipc.nmbclusters="65536"
> kern.maxfiles="65536"
> kern.maxfilesperproc="65536"
> net.inet.tcp.mssdflt="1460"
> kern.somaxconn="4096"
> kern.ipc.semmns="272"
> kern.ipc.semmni="256"
>
> sysctl.conf:
>
> net.inet.tcp.rfc1323=1
> kern.ipc.somaxconn=1024
> kern.ipc.maxsockbuf=8388608
> net.inet.tcp.sendspace=3217968
> net.inet.tcp.recvspace=3217968
> kern.ipc.shmmax=66099200
> kern.ipc.shmmin=256
> kern.ipc.shmall=16138
>
> and kern.ipc values are now:
> kern.ipc.maxsockbuf: 8388608
> kern.ipc.sockbuf_waste_factor: 8
> kern.ipc.somaxconn: 1024
> kern.ipc.max_linkhdr: 16
> kern.ipc.max_protohdr: 60
> kern.ipc.max_hdr: 76
> kern.ipc.max_datalen: 136
> kern.ipc.nmbclusters: 65536
> kern.ipc.msgmax: 16384
> kern.ipc.msgmni: 40
> kern.ipc.msgmnb: 2048
> kern.ipc.msgtql: 40
> kern.ipc.msgssz: 8
> kern.ipc.msgseg: 2048
> kern.ipc.semmap: 30
> kern.ipc.semmni: 256
> kern.ipc.semmns: 272
> kern.ipc.semmnu: 30
> kern.ipc.semmsl: 60
> kern.ipc.semopm: 100
> kern.ipc.semume: 10
> kern.ipc.semusz: 92
> kern.ipc.semvmx: 32767
> kern.ipc.semaem: 16384
> kern.ipc.shmmax: 66099200
> kern.ipc.shmmin: 256
> kern.ipc.shmmni: 192
> kern.ipc.shmseg: 128
> kern.ipc.shmall: 16138
> kern.ipc.shm_use_phys: 0
> kern.ipc.shm_allow_removed: 0
> kern.ipc.mbuf_wait: 32
> kern.ipc.mbtypes: 7 550 3 0 0 0 0 0 0 0 0 0 0 0 0 0
> kern.ipc.nmbufs: 262144
> kern.ipc.nsfbufs: 8704
> kern.ipc.nsfbufspeak: 6
> kern.ipc.nsfbufsused: 0
> kern.ipc.m_clreflimithits: 0
> kern.ipc.mcl_pool_max: 0
> kern.ipc.mcl_pool_now: 0
> kern.ipc.maxsockets: 65536
>
>
> Postgres still refuses to start with 256 max_connections.
>
> Chris.
>
>
>
>


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.2 - Release Date: 5/2/2005