Re: Worse perfomance on 8.2.0 than on 7.4.14 - Mailing list pgsql-performance

From Rolf Østvik
Subject Re: Worse perfomance on 8.2.0 than on 7.4.14
Date
Msg-id 22580.68259.qm@web26303.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: Worse perfomance on 8.2.0 than on 7.4.14  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Worse perfomance on 8.2.0 than on 7.4.14
List pgsql-performance
--- Tom Lane <tgl@sss.pgh.pa.us> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: More 8.2 client issues (Was: [Slow dump?)
Next
From: Tom Lane
Date:
Subject: Re: Worse perfomance on 8.2.0 than on 7.4.14