Re: Joins and their efficiencies

Hadley Willan <hadley.willan@deeperdesign.co.nz> writes:
> Is it correct then to assume that a LEFT JOIN is more efficient than a
> straight join?

Not at all.  I would imagine that the left join forced the planner to
adopt a different plan than it used otherwise (perhaps a different join
order), and that this other plan was much faster than the original,
whereas the planner's estimate had it slower (else it would have used
that plan to begin with).

It could also be that the change in the WHERE clauses had something to
do with it.

If you want to investigate further, make sure your ANALYZE stats are up
to date, then post EXPLAIN ANALYZE results for both queries.

            regards, tom lane