Re: Advice sought : new database server
От | Jochen Erwied |
---|---|
Тема | Re: Advice sought : new database server |
Дата | |
Msg-id | 417510800.20120308171558@erwied.eu обсуждение исходный текст |
Ответ на | Re: Advice sought : new database server (Shaun Thomas <sthomas@peak6.com>) |
Ответы |
Re: Advice sought : new database server
|
Список | 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 по дате отправления: