Re: shared memory settings: SHMMAX and SHMALL

Поиск
Список
Период
Сортировка
От Matthew Rice
Тема Re: shared memory settings: SHMMAX and SHMALL
Дата
Msg-id lv8zm7w5vm.fsf@sol.starnix.com
обсуждение исходный текст
Ответ на shared memory settings: SHMMAX and SHMALL  (Gregory Bittar <gbittar@iqa.cc>)
Список pgsql-general
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > If I have 512MB of memory in my system, excluding swap
> > space,
> > what values do I want to set for SHMMAX and SHMALL?
>
> That depeneds on your kernel implemetaion and hardware. I found
> followings in /usr/include/asm/shmparam.h on my Linux box.
>
> here PAGE_SIZE == 4096. So I guess we cannot have more than 128MB for
> the shared memory on this platform if above comment is correct.

You can recompile the kernel with the new defaults or just change them on
a live system (kernel 2.2.x or higher) with something like:

   echo 419430400 >/proc/sys/kernel/shmall
   echo 419430400 >/proc/sys/kernel/shmmax

You pick the numbers, of course.
--
matthew rice <matt@starnix.com>                               starnix inc.
tollfree: 1-87-pro-linux                        thornhill, ontario, canada
http://www.starnix.com              professional linux services & products

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

Предыдущее
От: "Russell Hires"
Дата:
Сообщение: Re: Re: Prompt question
Следующее
От: Christopher Sawtell
Дата:
Сообщение: Minor disaster after upgrading with cvs.