Re: Upper limit on number of buffers? - Mailing list pgsql-hackers

From Michael J Schout
Subject Re: Upper limit on number of buffers?
Date
Msg-id Pine.LNX.4.10.10012291127170.5623-100000@galaxy.gkg-com.com
Whole thread Raw
In response to Re: Upper limit on number of buffers?  ("Joe Conway" <joe@conway-family.com>)
List pgsql-hackers
On Sun, 24 Dec 2000, Joe Conway wrote:

>  Linux
> 
>  The default shared memory limit (both SHMMAX and SHMALL) is 32 MB in 2.2
> kernels, but it can be changed in the proc file system (without reboot). For
> example, to allow 128 MB:
> 
>  $ echo 134217728 >/proc/sys/kernel/shmall
> $ echo 134217728 >/proc/sys/kernel/shmmax
> You could put these commands into a script run at boot-time.

On redhat 6.2 I know that you can use /etc/sysctl.conf to do this as well.

Just add this to /etc/sysctl.conf.

kernel.shmall = 134217728
kernel.shmmax = 134217728

After this, your tunables will be restored every time that the system boots.

Mike



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: vacuum crash on 6.5.3
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: Assuming that TAS() will succeed the first time is verboten