Re: Postgres 8.3 vs. 8.4 - Query plans and performance

> Hello
>
> 2011/3/14 Jo <jl.news@uni-bonn.de>:
>> 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