From owner-freebsd-questions@FreeBSD.ORG Wed Feb 28 23:05:05 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 14F1016A401 for ; Wed, 28 Feb 2007 23:05:05 +0000 (UTC) (envelope-from dino_vliet@yahoo.com) Received: from web51106.mail.yahoo.com (web51106.mail.yahoo.com [206.190.38.148]) by mx1.freebsd.org (Postfix) with SMTP id A792113C474 for ; Wed, 28 Feb 2007 23:05:04 +0000 (UTC) (envelope-from dino_vliet@yahoo.com) Received: (qmail 55659 invoked by uid 60001); 28 Feb 2007 23:05:02 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=aJb1FHpcktq1hNuZ7Bk+pFew4X0VK/eB7GyynxHO1YyudHQoAERL0p9oS2kS9M0FxUk+A3hd2fIc6pNaKOyT/gJO/QRUDEj7SClzD0lPPs0qmbVqLGYTEyy/YtfXs51RaQqZ/eIGD01jSDvSQMbkXXQd7FzD5xHWGGXmAWnOcbk=; X-YMail-OSG: LEbcRYcVM1my1v7eN0L96vzkXGmZcW9zyKu4pXE9kkGJRY38TCdMyYTNEaAcPNHU1ybjDOVzjaIZBIl9yQCTLncvt.jjEU0L_KOQ1jnQApOkvDctT9XYB4zVZkrxUDcx9NCKIVSbAKIULnCzSeKBcH1Jgg-- Received: from [82.170.181.144] by web51106.mail.yahoo.com via HTTP; Wed, 28 Feb 2007 15:05:01 PST X-Mailer: YahooMailRC/468 YahooMailWebService/0.6.132.8 Date: Wed, 28 Feb 2007 15:05:01 -0800 (PST) From: Dino Vliet To: freebsd-questions@freebsd.org MIME-Version: 1.0 Message-ID: <60514.55113.qm@web51106.mail.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: tweaking kern.ipc.shmmax X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Feb 2007 23:05:05 -0000 Hi peeps,=0A=0AI have a amd64 system running freebsd6.1 with 3 GB ram. I wa= nt to use this a s my primary reserach database and installed postgresql on= it. There they are talking about increasing some shared buffers value.=0A= =0AHowever, if I do increase that shared buffer value to even 64MB (while I= hoped to increase it up to 256MB), in the var/log/messages file I get this= error:=0A=0AFeb 28 23:43:09 zouk postgres[826]: [1-1] FATAL: could not cr= eate shared memory segment: Cannot allocate memory=0AFeb 28 23:43:09 zouk p= ostgres[826]: [1-2] DETAIL: Failed system call was shmget(key=3D5432001, s= ize=3D71942144, 03600).=0AFeb 28 23:43:09 zouk postgres[826]: [1-3] HINT: = This error usually means that PostgreSQL's request for a shared memory segm= ent exceeded available memory or swap space.=0AFeb 28 23:43:09 zouk postgre= s[826]: [1-4] To reduce the request size (currently 71942144 bytes), reduc= e PostgreSQL's shared_buffers parameter (currently 8192) and/or its=0AFeb 2= 8 23:43:09 zouk postgres[826]: [1-5] max_connections parameter (currently = 3).=0AFeb 28 23:43:09 zouk postgres[826]: [1-6] The PostgreSQL docume= ntation contains more information about shared memory configuration.=0A=0A= =0AHowever, look at the values I have put in my /etc/rc.conf file:=0A=0Asys= ctl -w kern.ipc.shmmax=3D1954311424=0Asysctl -w kern.ipc.shmall=3D16384=0A= =0AI don't understand why the value that seems smaller, 71942144, doesn't f= it in the shmmax value.=0A=0ACan anyone be of assistance? Do I need to rebu= ild my kernel? Someone advised in 2006 that these value should be in your k= ernel:=0A options PMAP_SHPGPERPROC=3D201=0Aoptions KVA_PAGE= S=3D260=0A=0AThe fact is that tha both are not in my current kernel, but ev= en if they did, I wouldn't know which values to give them.=0ACan anyone hel= p me out?=0A=0AThanks=0A=0A=0A=0A=0A=0A =0A________________________________= ____________________________________________________=0AAny questions? Get a= nswers on any topic at www.Answers.yahoo.com. Try it now.