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 3E0375374B for ; Wed, 4 May 2005 02:17:38 -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 86790-03 for ; Wed, 4 May 2005 05:17:29 +0000 (GMT) Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [202.0.58.20]) by svr1.postgresql.org (Postfix) with ESMTP id 38CCC52A43 for ; Wed, 4 May 2005 02:17:26 -0300 (ADT) Received: from smtp-3.paradise.net.nz (smtp-3b.paradise.net.nz [202.0.32.212]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IFY00EP49CL26@linda-1.paradise.net.nz> for pgsql-performance@postgresql.org; Wed, 04 May 2005 17:17:13 +1200 (NZST) Received: from [192.168.1.11] (218-101-13-88.paradise.net.nz [218.101.13.88]) by smtp-3.paradise.net.nz (Postfix) with ESMTP id E01FEAE5FF; Wed, 04 May 2005 17:16:56 +1200 (NZST) Date: Wed, 04 May 2005 17:16:36 +1200 From: Mark Kirkwood Subject: Re: Kernel Resources and max_connections In-reply-to: <42782DA5.70701@wildcash.com> To: Chris Hebrard Cc: pgsql-performance@postgresql.org Message-id: <42785AB4.5080206@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8b) Gecko/20050301 References: <42782194.7040500@wildcash.com> <4278297A.1010703@paradise.net.nz> <42782DA5.70701@wildcash.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.138 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/37 X-Sequence-Number: 12201 Chris Hebrard wrote: > > I set the values in etc/sysctl.conf: > > # $FreeBSD: src/etc/sysctl.conf,v 1.1.2.3 2002/04/15 00:44:13 dougb Exp $ > # > # This file is read when going to multi-user and its contents piped thru > # ``sysctl'' to adjust kernel values. ``man 5 sysctl.conf'' for details. > # > # Added by IMP 2005-05-04 > 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.semmns="272" > kern.ipc.semmni="256" > kern.ipc.shmmax="66099200" > kern.ipc.shmmin="256" > > > After a restart both shmmax and shmmin are now 0 and postgres failed to > start. > > Hmmm - puzzling. One point to check, did you take them out of /boot/loader.conf ? Assuming so, maybe don't quote 'em (see below). Finally you need to to set shmall, otherwise it will over(under)ride the shmmax setting. So try: 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.semmns=272 kern.ipc.semmni=256 kern.ipc.shmmax=66099200 kern.ipc.shmmin=256 kern.ipc.shmall=32768