Re: [PERFORM] Many to many join seems slow?

[Daniel Cristian Cruz]

2007/5/15, Drew Wilson <[EMAIL PROTECTED]>:

=# 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings