X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8641DD8D80 for ; Thu, 22 Sep 2005 18:48:32 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24328-08 for ; Thu, 22 Sep 2005 21:48:28 +0000 (GMT) Received: from sccmmhc91.asp.att.net (sccmmhc91.asp.att.net [204.127.203.211]) by svr1.postgresql.org (Postfix) with ESMTP id 1E9B5D8D74 for ; Thu, 22 Sep 2005 18:48:24 -0300 (ADT) Received: from juju.arbash-meinel.com ([12.214.18.81]) by sccmmhc91.asp.att.net (sccmmhc91) with ESMTP id <20050922214825m9100psmpde>; Thu, 22 Sep 2005 21:48:26 +0000 Received: by juju.arbash-meinel.com (Postfix, from userid 505) id 8C79D55FF0; Thu, 22 Sep 2005 16:48:25 -0500 (CDT) Received: from [192.168.1.11] (liliana.arbash-meinel.com [192.168.1.11]) by juju.arbash-meinel.com (Postfix) with ESMTP id E98CF55FA4; Thu, 22 Sep 2005 16:48:22 -0500 (CDT) Message-ID: <433326A6.8010708@arbash-meinel.com> Date: Thu, 22 Sep 2005 16:48:22 -0500 From: John Arbash Meinel User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050727) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jean-Pierre Pelletier Cc: pgsql-performance@postgresql.org Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0 References: In-Reply-To: X-Enigmail-Version: 0.92.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigC8079ADE35788585F32912F2" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.045 required=5 tests=[AWL=-0.005, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/252 X-Sequence-Number: 14560 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigC8079ADE35788585F32912F2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 > --------------enigC8079ADE35788585F32912F2 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDMyamJdeBCYSNAAMRAomXAJ9Pe/jFwz3tAH7mWpeBw3tUtPoSWQCdH3t1 nd0YRSnI/FfkVKZoyaiz3fU= =sJoX -----END PGP SIGNATURE----- --------------enigC8079ADE35788585F32912F2--