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!

 

Leave a Reply

Powered by WordPress.com.

Up ↑

%d bloggers like this: