SHMMAX and SHMALL question
От
DM
Тема
SHMMAX and SHMALL question
Дата
Msg-id
AANLkTimYwdqdvAPDSgMME4Vz=wRaLP9cP1NUZX3iTTF5@mail.gmail.com
Список
Дерево обсуждения
SHMMAX and SHMALL question DM <dm.aeqa@gmail.com>
Re: SHMMAX and SHMALL question Greg Smith <greg@2ndquadrant.com>
Re: SHMMAX and SHMALL question D M <dm.aeqa@gmail.com>
Re: SHMMAX and SHMALL question Scott Marlowe <scott.marlowe@gmail.com>
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
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
Дата:
От: Andy Colson
Дата:
