X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 41F3653873 for ; Tue, 3 May 2005 23:40:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61397-07 for ; Wed, 4 May 2005 02:40:26 +0000 (GMT) Received: from hummer.onthenet.com.au (hummer.OntheNet.com.au [203.13.68.9]) by svr1.postgresql.org (Postfix) with ESMTP id E8BCE535C2 for ; Tue, 3 May 2005 23:40:24 -0300 (ADT) Received: from [192.168.2.26] (imp5.dsl.onthenet.net [203.144.16.135]) by hummer.onthenet.com.au (Postfix) with ESMTP id 75B6F19FB68 for ; Wed, 4 May 2005 12:40:28 +1000 (EST) Received: from 127.0.0.1 (AVG SMTP 7.0.308 [266.11.2]); Wed, 04 May 2005 12:40:10 +1000 Message-ID: <4278360A.9050501@wildcash.com> Date: Wed, 04 May 2005 12:40:10 +1000 From: Chris Hebrard User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040616 X-Accept-Language: en-us, en To: pgsql-performance@postgresql.org Subject: Kernel Resources Solved X-Enigmail-Version: 0.89.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Mime-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/34 X-Sequence-Number: 12198 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