From: John Arbash Meinel <john@arbash-meinel.com>
To: Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Date: Thu, 22 Sep 2005 16:48:22 -0500
Message-ID: <433326A6.8010708@arbash-meinel.com> (raw)
In-Reply-To: <BAYC1-PASMTP01EE67AD3A0034394D85D895970@CEZ.ICE>
References: <BAYC1-PASMTP01EE67AD3A0034394D85D895970@CEZ.ICE>
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
>
Attachments:
signature.asc (application/pgp-signature, 255B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: john@arbash-meinel.com, pelletier_32@sympatico.ca
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
In-Reply-To: <433326A6.8010708@arbash-meinel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox