Re: Many to many join seems slow? - Mailing list pgsql-performance

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.