If shmmax and shmmall are too small, then: PostgreSQL requires some more shared memory to cache some tables, x Mb, do you want to increase your OS kernel parameters? Tweak shmmax and shmmall
CK> Note that this still requires a kernel recompile on FreeBSD :(
According to whom? sysctl is your friend. Some sysctl settings may require reboot, but I don't think the SHM ones do.
Hmmm...you may be right - I can't prove it now...
houston# sysctl -w kern.ipc.shmmax=99999999999 kern.ipc.shmmax: 33554432 -> 2147483647
Hrm. Ok. Maybe they've changed that in some recent version :)
Chris
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster