Hello, this seems as if some data was missing on a joined table ...
could you compare the result of
EXPLAIN ANALYZE
for that statement
between both databases ?
and maybe share them ?
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html