Hello,
that's the 8.4 query plan:
http://explain.depesz.com/s/dO7
The locale of the two databases is the same:
SHOW LC_COLLATE command gives the locale: "de_DE.UTF-8".
Regards,
Jo
On 14.03.2011 16:04, tv@xxxxxxxx wrote:
Hello
2011/3/14 Jo<jl.news@xxxxxxxxxxx>:
I set the work_mem to 100MB and the shared buffers are 2 GB
The query plans are long and complex. I send the beginning of the
two plans. Hope this helps to understand the differences.
I assume the join strategy in 8.3 differs from the one in 8.4.
these outputs are not too helpful - send a EXPLAIN ANALYZE result
you can use a small aplication for storing plans
http://explain.depesz.com/
I'm afraid he won't be able to provide EXPLAIN ANALYZE as the second query
(on 8.4) does not finish. But providing a full EXPLAIN output is
definitely a good idea - there's no way to solve that using just a piece
of it.
regards
Tomas
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
