Jim Nasby <[EMAIL PROTECTED]> writes: > I'm guessing the issue here is shmall, which I believe is limiting > you to 4MB of shared memory. Is there *anything* using shared memory > in the ipcs report?
Right, it looks like shmall is the problem. I believe BTW that you need to do "sudo ipcs -a" to be sure of seeing everything; otherwise OS X's ipcs silently doesn't tell you about segments your userid doesn't have access to. regards, tom lane ---------------------------(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