X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 77B0530ECCE for ; Mon, 16 Jun 2003 14:17:59 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 33865-05 for ; Mon, 16 Jun 2003 11:17:49 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B434F30DE85 for ; Mon, 16 Jun 2003 11:17:48 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5GEHiU6002681; Mon, 16 Jun 2003 10:17:44 -0400 (EDT) To: Ryszard Lach Cc: pgsql-performance@postgresql.org Subject: Re: 7.3 vs 7.2 - different query plan, bad performance In-reply-to: <20030616114147.GJ1734@siaco.id.pl> References: <20030613184506.GE21614@siaco.id.pl> <20030616063850.GA31813@siaco.id.pl> <373rev0fotgpq2osvlldf41b8flambulk9@4ax.com> <20030616114147.GJ1734@siaco.id.pl> Comments: In-reply-to Ryszard Lach message dated "Mon, 16 Jun 2003 13:41:47 +0200" Date: Mon, 16 Jun 2003 10:17:43 -0400 Message-ID: <2680.1055773063@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/91 X-Sequence-Number: 2175 Ryszard Lach writes: > The point is, that my tables (and queries) are a 'little' bit more > complicated and I wanted to give as simple example as I could. I think > that problem is that subselects are _much_slower_ executed in 7.3 than > in 7.2, just as someone already wrote here. No, the problem is that 7.3 fails to notice that it doesn't really need to execute the subselect at all. This is the price we paid for being sure that a post-release bug fix wouldn't break anything more serious. There is a better fix in place for 7.4. regards, tom lane