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 stho...@peak6.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
