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 <drewmwilson(at)gmail(dot)com>:
>> =# 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