Postgres performance tuning – shmmax

Kudos to this blog for helping with postgres performance tuning.

http://www.revsys.com/writings/postgresql-performance.html

Per the blog, the biggest change that you’ll notice is the shared_buffers change. I tried this, but got into kernel shmmax settings when I tried to set it. So, here’s how to change the kernal shmmax parameter in ubuntu:

1. sudo  /sbin/sysctl -w kernel.shmmax=<bytes>
2. sudo vi /etc/sysctl.conf
   1. set kernel.shmmax = <bytes>

That’s it!