[GENERAL] Changing SHMMAX

2011-02-02 Thread Adarsh Sharma
Dear all, Today i try to perform some performance tuning for Postgresql database. I want to change my shared memory permanently. I have 16 GB RAM. Please guide me how to change it permanently and what is the correct value for it. I am going for 8GB . Thanks Regards Adarsh Sharma --

Re: [GENERAL] Changing SHMMAX

2011-02-02 Thread Florian Weimer
* Adarsh Sharma: Please guide me how to change it permanently and what is the correct value for it. I am going for 8GB . Usually, you can put these lines kernel.shmall = 90 kernel.shmmax = 90 into /etc/sysctl.conf. Run sysctl -p to activate them. However, this is a bit

Re: [GENERAL] Changing SHMMAX

2011-02-02 Thread Torsten Zühlsdorff
Florian Weimer schrieb: Please guide me how to change it permanently and what is the correct value for it. I am going for 8GB . Usually, you can put these lines kernel.shmall = 90 kernel.shmmax = 90 into /etc/sysctl.conf. Run sysctl -p to activate them. However, this is

Re: [GENERAL] Changing SHMMAX

2011-02-02 Thread Vick Khera
On Wed, Feb 2, 2011 at 10:31 AM, Torsten Zühlsdorff f...@meisterderspiele.de wrote: kernel.shmall = 90 kernel.shmmax = 90 into /etc/sysctl.conf.  Run sysctl -p to activate them.  However, this is a bit distribution-specific. If you're using FreeBSD you even have to restart