On 2/17/2016 6:39 AM, Michael H wrote:
Some additional information;
sysctl -a | grep kernel.shm kernel.shmall = 8650752 kernel.shmmax = 35433480192 kernel.shmmni = 4096
which corresponds to my /etc/sysctl.conf kernel.shmmax=35433480192 kernel.shmall=8650752
but contradicts; ulimit -a [...] stack size (kbytes, -s) 8192
SysV Shared Memory has nothing to do with stack size.
note, btw, the latest releases of postgres (I think as of 9.3?) no longer need large values of shmall,shmmax as they now use a different method of allocating the shared_buffers ...