Re: Advice sought : new database server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx     +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work: joe@xxxxxxxxxxxxxxx  +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile: jochen.erwied@xxxxxxxxxxx       +49-173-5404164


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux