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?
Tom Lane wrote:
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 4: Have you searched our list archives?
http://archives.postgresql.org
