Search Postgresql Archives

SHMMAX and SHMALL question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux