Ben <bench@xxxxxxxxxxxxxxx> writes: > Are full outer joins expected to perform much worse than inner joins? You're getting burnt by the outer join forcing a bad join order. There's some related discussion here: http://www.postgresql.org/docs/8.0/static/explicit-joins.html 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
