>>>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