On 31/05/2010 10:34 PM, Alonso García , Bruno Elier wrote:
> If I perform the query using pgadmin I get the same result in both versions 7.4 and version 8.3.
Please post the output of EXPLAIN ANALYZE for each. See:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
and
http://wiki.postgresql.org/wiki/Using_EXPLAIN
--
Craig Ringer