Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id C814F119C296 for ; Thu, 8 Mar 2012 12:16:40 -0400 (AST) Received: from mail.erwied.eu ([85.214.80.157]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5g17-0004yy-VP for pgsql-performance@postgresql.org; Thu, 08 Mar 2012 16:16:39 +0000 Received: from dslb-188-100-130-120.pools.arcor-ip.net ([188.100.130.120] helo=erwied.dyndns.org ident=nobody) by mail.erwied.eu with esmtpsa (Exim 4.76#1) id 1S5g0X-0001Zx-4a ; Thu, 08 Mar 2012 17:16:01 +0100 Received: from [212.89.222.155] (helo=[192.168.1.47]) by erwied.dyndns.org with esmtpsa (Exim 4.77#2) id 1S5g0V-0003VW-Pi ; Thu, 08 Mar 2012 17:15:59 +0100 Date: Thu, 8 Mar 2012 17:15:58 +0100 From: Jochen Erwied Organization: Creative Chaos Computing X-Priority: 3 (Normal) Message-ID: <417510800.20120308171558@erwied.eu> To: Shaun Thomas CC: pgsql-performance@postgresql.org Subject: Re: Advice sought : new database server In-Reply-To: <4F57E019.8050002@peak6.com> References: <20120304095838.GA3064@campbell-lange.net> <20120304183630.GA8902@campbell-lange.net> <4F57E019.8050002@peak6.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.1 (-) X-Archive-Number: 201203/81 X-Sequence-Number: 46531 Wednesday, March 7, 2012, 11:24:25 PM you wrote: > On 03/07/2012 03:07 PM, Craig James wrote: >> echo 4294967296 >/proc/sys/kernel/shmmax # 4 GB shared memory >> echo 4096 >/proc/sys/kernel/shmmni >> echo 1572864 >/proc/sys/kernel/shmall # 6 GB max shared mem (block size >> is 4096 bytes) > For what it's worth, you can just make these entries in your > /etc/sysctl.conf file and it'll do the same thing a little more cleanly: > vm.shmmax = 4294967296 > vm.shmmni = 4096 > vm.shmall = 1572864 Shouldn't that be: kernel.shmmax = 4294967296 kernel.shmmni = 4096 kernel.shmall = 1572864 -- Jochen Erwied | home: jochen@erwied.eu +49-208-38800-18, FAX: -19 Sauerbruchstr. 17 | work: joe@mbs-software.de +49-2151-7294-24, FAX: -50 D-45470 Muelheim | mobile: jochen.erwied@vodafone.de +49-173-5404164