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

From Shaun Thomas
Subject Re: Advice sought : new database server
Date
Msg-id 4F57E019.8050002@peak6.com
Whole thread Raw
In response to Re: Advice sought : new database server  (Craig James <cjames@emolecules.com>)
Responses Re: Advice sought : new database server
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: Advice sought : new database server
Next
From: Ants Aasma
Date:
Subject: Re: Advice sought : new database server