Re: full outer join performance

Ben <bench@silentmedia.com> 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