Bill Moran <wmoran@xxxxxxxxxxxxxxxxxxxxxxx> writes: > In response to Christiaan Willemsen <cwillemsen@xxxxxxxxxxxxx>: >> #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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
