Re: Managing Kernal resource - Mailing list pgsql-general

From Tom Lane
Subject Re: Managing Kernal resource
Date
Msg-id 22886.1181311644@sss.pgh.pa.us
Whole thread Raw
In response to Managing Kernal resource  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
List pgsql-general
"Ashish Karalkar" <ashish.karalkar@info-spectrum.com> writes:
> As per documantation on :

> http://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/admin_user/=
> kernel-resources.html

Why in the world are you consulting PG 7.1 documentation for help in
managing an 8.2 installation?  That manual is so obsolete as to be
seriously misleading.

> But I am not getting the count of number of buffres.
> In postgres.conf file there is size of shared buffer.
> shared_buffer=24 MB.

So you need 24MB (plus some slop) SHMMAX.

In any case, there's no harm in making SHMMAX big.  Just set it to
100M or 1G and be done with it.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Apparent Wraparound?
Next
From: Vincenzo Romano
Date:
Subject: Wider than float8