Re: Managing Kernal resource

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Managing Kernal resource
Дата
Msg-id 22886.1181311644@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Managing Kernal resource  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Apparent Wraparound?
Следующее
От: Vincenzo Romano
Дата:
Сообщение: Wider than float8