| From: | Jochen Erwied <jochen(at)pgsql-performance(dot)erwied(dot)eu> |
|---|---|
| To: | Shaun Thomas <sthomas(at)peak6(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Advice sought : new database server |
| Date: | 2012-03-08 16:15:58 |
| Message-ID: | 417510800.20120308171558@erwied.eu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)erwied(dot)eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe(at)mbs-software(dot)de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen(dot)erwied(at)vodafone(dot)de +49-173-5404164
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Thomas | 2012-03-08 16:18:30 | Re: Advice sought : new database server |
| Previous Message | Jeff Janes | 2012-03-08 16:03:42 | Re: Advice sought : new database server |