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:
- sudo /sbin/sysctl -w kernel.shmmax=<bytes>
- sudo vi /etc/sysctl.conf
- set kernel.shmmax = <bytes>
That’s it!
Leave a Reply