Bill Moran <wmoran@collaborativefusion.com> writes:
> In response to Christiaan Willemsen <cwillemsen@technocon.com>:
>> #sysctl -a | grep shm
>> kern.ipc.shm_allow_removed: 0
>> kern.ipc.shm_use_phys: 1
>> kern.ipc.shmall: 68719476736
>> kern.ipc.shmseg: 128
>> kern.ipc.shmmni: 192
>> kern.ipc.shmmin: 1
>> kern.ipc.shmmax: 68719476736
> Try bumping shmmni:
I'm wondering about the shmall setting myself. The Postgres docs
suggest that FreeBSD measures shmall in pages. If so, the above
setting is far too large and is perhaps resulting in an internal
overflow in the kernel.
(For that matter, are you certain that shmmax can be set beyond
2G either? It might only be int inside the kernel.)
regards, tom lane