Re: Worse perfomance on 8.2.0 than on 7.4.14

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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