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

[Alvaro Herrera]

Drew Wilson escribió:

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

Please provide an EXPLAIN ANALYZE of the query.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org