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(at)silentmedia(dot)com> 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
>
>