Re: Many to many join seems slow?

2007/5/15, Drew Wilson :
> =# explain SELECT s.source_id, s.value AS sourceValue, t.value AS
> translationValue
>        FROM
>            source s,
>            translation_pair tp,
>            translation t,
>            language l
>        WHERE
>            s.source_id = tp.source_id
>            AND tp.translation_id = t.translation_id
>            AND t.language_id = l.language_id
>            AND l.name = 'French' ;
>
>                                                           QUERY PLAN
> ------------------------------------------------------------------------
> -----------------------------------------------------
> Merge Join  (cost=524224.49..732216.29 rows=92447 width=97)

This way you get all word matches for the French language. Shouldn't
it be all matches for a specific word (s.value = 'word' in WHERE)?

-- 
Daniel Cristian Cruz