Re: full outer join performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben <bench(at)silentmedia(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: full outer join performance
Date: 2005-09-13 18:12:28
Message-ID: 25571.1126635148@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Warren Bell 2005-09-13 18:20:07 Speed problems
Previous Message Ben 2005-09-13 17:36:00 full outer join performance