On 17/02/16 19:55, John R Pierce wrote: > 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 ... > Hi John, I dived into the issue in a panic, trying to fix something that was completely unrelated. Turns out my service file was overwritten and lost my stack setting. I've resolved it now with a drop-in snippet. I like the look of the new features in postgresql but we are using postgresql-server.x86_64 9.2.14-1.el7_1. Thanks for the information, Michael