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

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(at)fuzzy(dot)cz wrote:
>> Hello
>>
>> 2011/3/14 Jo<jl(dot)news(at)uni-bonn(dot)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
>
>