When you increase shmmax, you need to increase shmall as well. Max is the largest single allocation allowed, in bytes. All is the total SysV shared memory available to all processes, in pages. (I think...)
-- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---------------------------(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