Re: Queries 15 times slower on 8.1 beta 2 than on 8.0

Jean-Pierre Pelletier wrote:
> Hi,
>
> I've got many queries running much slower on 8.1 beta2 than on 8.0.1
> Here is a simplified one that takes 484 ms on 8.1 and 32 ms on 8.0.1.
>
> select
>   0
> from
>   Content C
>
>   left outer join Supplier S
>   on  C.SupplierId = S.SupplierId
>
>   left outer join Price P
>   on C.PriceId = P.PriceId;
>
> Any ideas why it's slower?

You really have to post the results of "EXPLAIN ANALYZE" not just
explain. So that we can tell what the planner is expecting, versus what
really happened.

John
=:->

>
> Thanks
> Jean-Pierre Pelletier
> e-djuster
>