Ben <bench@xxxxxxxxxxxxxxx> writes:
> Hrm, as I understand that page, there's not much that can be done about
> the join order for outer joins. At least, not when there's on 3 tables
> and 1 outer join involved. Am I missing something?
Without knowing what you want the query to do, it's difficult to say if
it's OK to rearrange the join order.
Frequently it's OK to rearrange the join order even without risking any
change in the query results, but PG doesn't currently have any smarts
about that, so you have to do it manually by changing the query.
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
