Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> Sometimes putting a where clause portion into the on clause helps.
> like:
> select * from a left join b on (a.id=b.id) where a.somefield=2
> might run faster with
> select * from a left join b on (a.id=bid. and a.somefield=2);
> but it's hard to say.
Uh, those are not the same query ... they will give different results
for rows with a.somefield different from 2.
regards, tom lane