Message-ID: <4F57E019.8050002@peak6.com>
Date: Wed, 7 Mar 2012 16:24:25 -0600
From: Shaun Thomas <sthomas@peak6.com>
Reply-To: <sthomas@peak6.com>
Organization: Peak6
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
To: Craig James <cjames@emolecules.com>
CC: Merlin Moncure <mmoncure@gmail.com>, Rory Campbell-Lange
	<rory@campbell-lange.net>, Scott Marlowe <scott.marlowe@gmail.com>,
	<pgsql-performance@postgresql.org>
Subject: Re: Advice sought : new database server
References: <20120304095838.GA3064@campbell-lange.net>
	<CAOR=d=1L=aunEtULW2sq9c-tAdZzSM6exi6wUw0w_zzjGLBRHQ@mail.gmail.com>
	<20120304183630.GA8902@campbell-lange.net>
	<CAFwQ8rc01cv61tvcUiyo=Xo_2g+kCges4PDosnPnpLP4x49SxQ@mail.gmail.com>
	<CAHyXU0yKEcG_BPMevJXVsLoZ=w7-VU29Ngrwp1eOOkPvvMYQ+A@mail.gmail.com>
	<CAFwQ8rf9pfAQgDwfxgrB3dt=9c2Hbu51DYU8jVeQC=mAWLQhjQ@mail.gmail.com>
In-Reply-To: 
 <CAFwQ8rf9pfAQgDwfxgrB3dt=9c2Hbu51DYU8jVeQC=mAWLQhjQ@mail.gmail.com>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
content-transfer-encoding: 7bit

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

To commit changes made this way:

sysctl -p

-- 
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@peak6.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email