Re: Upper limit on number of buffers?

From: Michael J Schout <mschout(at)gkg(dot)net>
To: Joe Conway <joe(at)conway-family(dot)com>
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>, mlw <markw(at)mohawksoft(dot)com>
Subject: Re: Upper limit on number of buffers?
Date: 2000-12-29 17:29:21
Message-ID: Pine.LNX.4.10.10012291127170.5623-100000@galaxy.gkg-com.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2000-12-29 18:54:00 RE: Assuming that TAS() will succeed the first time is verboten
Previous Message Tatsuo Ishii 2000-12-29 14:16:36 Re: vacuum crash on 6.5.3