Re: Many to many join seems slow?

Yes, I'll be filtering by string value. However, I just wanted to see  
how long it takes to scan all translations in a particular language.

Drew

On May 15, 2007, at 9:00 AM, Daniel Cristian Cruz wrote:

> 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