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://stream.boxwatch.ru/docs/8.0/static/explicit-joins.html
regards, tom lane