SHMMAX and SHMALL question

Поиск
Список
Период
Сортировка
От DM
Тема SHMMAX and SHMALL question
Дата
Msg-id AANLkTimYwdqdvAPDSgMME4Vz=wRaLP9cP1NUZX3iTTF5@mail.gmail.com
обсуждение исходный текст
Ответы Re: SHMMAX and SHMALL question
Re: SHMMAX and SHMALL question
Список pgsql-general
Дерево обсуждения
Firstof all sorry for posting linux kernel question in pgsql-general, but i am trying to figure out what value to set for postgresql db server.

RAM = 16GB, what value should i set for shmall?

 If i set shmall to 4294967296 (4GB), current PAGE_SIZE is 4096 should i need to set my shmmax = 4294967296*4096 = 17592186044416?


cat /proc/sys/kernel/shmall
4294967296

getconf PAGE_SIZE
4096

Current Shmmax -
==> cat /proc/sys/kernel/shmmax
68719476736

should i need to increase my shmmax to 17592186044416?

also what value should i need to set shmall?

what happens if i set shmmax to lower  than the expected size?


Thanks
Deepak

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

Предыдущее
От: "Karsten Hilbert"
Дата:
Сообщение: Re: Are there any projects interested in object functionality? (+ rule bases)
Следующее
От: Andy Colson
Дата:
Сообщение: Re: Are there any projects interested in object functionality? (+ rule bases)