Re: Advice sought : new database server - Mailing list pgsql-performance

From Jochen Erwied
Subject Re: Advice sought : new database server
Date
Msg-id 417510800.20120308171558@erwied.eu
Whole thread Raw
In response to Re: Advice sought : new database server  (Shaun Thomas <sthomas@peak6.com>)
Responses Re: Advice sought : new database server  (Shaun Thomas <sthomas@peak6.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Advice sought : new database server
Next
From: Shaun Thomas
Date:
Subject: Re: Advice sought : new database server