| From: | Shaun Thomas <sthomas(at)peak6(dot)com> |
|---|---|
| To: | Craig James <cjames(at)emolecules(dot)com> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Rory Campbell-Lange <rory(at)campbell-lange(dot)net>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Advice sought : new database server |
| Date: | 2012-03-07 22:24:25 |
| Message-ID: | 4F57E019.8050002@peak6.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)peak6(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ants Aasma | 2012-03-08 12:43:10 | Re: Advice sought : new database server |
| Previous Message | Craig James | 2012-03-07 21:07:41 | Re: Advice sought : new database server |