Here are my kernel settings kernel.shmmax = 10737418240
# Maximum total size of all shared memory segments in pages (normally 4096 bytes) kernel.shmall = 2621440 kernel.sem = 250 32000 32 1200 They are actually set... sysctl -a | grep shm kernel.shmmax = 10737418240 kernel.shmall = 2621440 kernel.shmmni = 4096 To reduce the request size [FAILently 2232950784 bytes), reduce PostgreSQL's shared memory usage, Dave Cramer
