Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 43E2B9FA31B for ; Wed, 3 Jan 2007 04:01:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 93701-10 for ; Wed, 3 Jan 2007 04:01:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web26303.mail.ukl.yahoo.com (web26303.mail.ukl.yahoo.com [217.146.176.14]) by postgresql.org (Postfix) with SMTP id E16E49F95E3 for ; Wed, 3 Jan 2007 04:01:39 -0400 (AST) Received: (qmail 70459 invoked by uid 60001); 3 Jan 2007 08:01:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.no; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=1EmMP1mckqdwXN2pbvDw4yQFcJWra9jeiuuiVCiJI0EFMm669HZ0P6Z8DDYP+tCaZvZrwBubwqqIJJ3NEp99BlCzjza7s5jGaQQqFCGk+KIQpScdSuCJZOErwtHuTp2HYi0hXVhjg1vnzlwfqVMxtesxN+Cd0utwCpgyDhm1fBU=; X-YMail-OSG: RpYrqpIVM1kMHHVIgnNkNdJCDP3FyuO_LidDs9Ty.AGBj9AMhacng.L_rElfSTjpWycYFQym9a4nYMqWkQ_6z4TlYyPOEQq4EeAA.C5Sra1w3_Xyeho6IrD8xz7mhY.7pHft7PyPq0rj Received: from [81.175.5.65] by web26303.mail.ukl.yahoo.com via HTTP; Wed, 03 Jan 2007 09:01:37 CET Date: Wed, 3 Jan 2007 09:01:37 +0100 (CET) From: =?iso-8859-1?q?Rolf=20=D8stvik?= Subject: Re: Worse perfomance on 8.2.0 than on 7.4.14 To: Tom Lane Cc: pgsql-performance@postgresql.org In-Reply-To: <3425.1167750444@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <22580.68259.qm@web26303.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/31 X-Sequence-Number: 22632 --- Tom Lane skrev: > > Please --- I'm still curious why the estimated cost changed so much from > 7.4 to 8.2. I can believe a marginal change in cost leading to a plan Is this the output you need? logistics_82=# prepare foo(int) as select id from step_result_subset where uut_Result = $1 and step_parent = 0; PREPARE logistics_82=# explain analyze execute foo(180226); QUERY PLAN ----------------------------------------------- Index Scan using step_result_uut_result_idx on step_result_subset (cost=0.00..563.85 rows=23 width=4) (actual time=0.069..0.069 rows=0 loops=1) Index Cond: (uut_result = $1) Filter: (step_parent = 0) Total runtime: 0.112 ms (4 rows) Best regards, Rolf Østvik __________________________________________________ Bruker du Yahoo!? Lei av spam? Yahoo! Mail har den beste spambeskyttelsen http://no.mail.yahoo.com