Why PostgreSQL doesn't start with shared_buffers=6GB ?

Yuri yuri at rawbw.com
Mon Nov 5 00:54:20 UTC 2012


When I am setting shared_buffers=6GB in postgresql.conf it fails to start:
DETAIL:  Failed system call was shmget(key=5432001, size=6612361216, 03600).
even though kern.ipc.shmmax is set to ~7GB:
$ sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 0
kern.ipc.shmall: 1310720
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax: 7000000000
kern.features.sysv_shm: 1
kern.features.posix_shm: 1

There are 17GB free memory as reported by top(1).

Why shmget fails despite kern.ipc.shmmax is being high enough?
Experimentally I found that shared_buffers=5GB also fails but 4GB 
succeeds. Is there another system limit on shmem besides kern.ipc.shmmax ?

9.1-RC3 and64

Yuri


More information about the freebsd-questions mailing list