Re: Managing Kernal resource

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Managing Kernal resource
Date: 2007-06-08 14:07:24
Message-ID: 22886.1181311644@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2007-06-08 14:09:10 Wider than float8
Previous Message Alvaro Herrera 2007-06-08 13:23:47 Re: Apparent Wraparound?