Rick Apichairuk <rapichai@xxxxxxxxx> writes: > This is confusing because the requested size is both higher than > SHMMIN and lower than SHMMAX as you can see below: SHMALL is the other limit that might cause this failure. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match