Re: [GENERAL] Changing SHMMAX

2011-02-02 Thread Vick Khera
On Wed, Feb 2, 2011 at 10:31 AM, Torsten Zühlsdorff 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 the machine.

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 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 b

[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 -- S