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