> 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
