On May 23, 2007, at 4:40 PM, Peter Schuller wrote:
Sounds like you need to increase your shared memory limits. Unfortunately this will require a reboot on FreeBSD :(
No, it does not. You can tune some of the sysv IPC parameters at runtime. the shmmax and shmall are such parameters.
---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match