Re: postgresql-8.0.1 performance tuning

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: postgresql-8.0.1 performance tuning
Дата
Msg-id 429D56B2.9070302@paradise.net.nz
обсуждение исходный текст
Ответ на Re: postgresql-8.0.1 performance tuning  (Cosimo Streppone <cosimo@streppone.it>)
Ответы Re: postgresql-8.0.1 performance tuning  (Cosimo Streppone <cosimo@streppone.it>)
SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)  (Paul McGarry <paul.mcgarry@gmail.com>)
Список pgsql-performance
Cosimo Streppone wrote:
> ######### Config ############
>> /etc/sysctl.conf:
>> kernel.shmall = 786432000
>> kernel.shmmax = 786432000
>
>
> I think you have a problem here.
> kernel.shmmax should *not* be set to an amount of RAM, but
> to maximum number of shared memory pages, which on a typical linux system
> is 4kb. Google around:
>
>
>

This is somewhat confusing :

kernel.shmmax is in bytes (max single segment size)
kernel.shmall is in (4k) pages (max system wide allocated segment pages)

cheers

Mark



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tobias Brox
Дата:
Сообщение: Re: Index on a NULL-value
Следующее
От: Cosimo Streppone
Дата:
Сообщение: Re: postgresql-8.0.1 performance tuning