On Nov 27, 2006, at 02:45 , Tom Lane wrote:
> Alexander Staubo <alex@purefiction.net> writes:
>> select comments.*, users.*
>> from comments
>> left outer join users on
>> users.id = comments.creator_id
>> inner join events_comments on
>> comments.id = events_comments.comment_id
>> and events_comments.event_id = 9244
>
>> The outer join seems unnecessarily slow.
>
> Try flipping the order of the two joins. PG 8.2 will be smart
> enough to
> do that for itself, but no existing release understands when it's safe
> to rearrange outer-join order.
That fixes it. Thanks.
Alexander.
