Re: out of memory woes

Поиск
Список
Период
Сортировка
От Angva
Тема Re: out of memory woes
Дата
Msg-id 1166563696.532099.250200@80g2000cwy.googlegroups.com
обсуждение исходный текст
Ответ на out of memory woes  ("Angva" <angvaw@gmail.com>)
Ответы Re: out of memory woes  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
We found that the kernel setting SHMALL was set ridiculously high -
1024g!. Someone noticed this when running "ipcs -lm" - seemed just a
tad off. :)

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 524288
max total shared memory (kbytes) = 1073741824
min seg size (bytes) = 1

Now it is set to ceil(SHMMAX/PAGE_SIZE) as recommended in the Postgres
documentation. Testing the heck out of the parallel clusters now...

Mark


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

Предыдущее
От: "Angva"
Дата:
Сообщение: Re: out of memory woes
Следующее
От: "Amit Mody"
Дата:
Сообщение: windows - silent uninstall question