From: | Rolf Østvik <rolfostvik(at)yahoo(dot)no> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Worse perfomance on 8.2.0 than on 7.4.14 |
Date: | 2007-01-03 08:01:37 |
Message-ID: | 22580.68259.qm@web26303.mail.ukl.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
--- 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-01-03 15:31:32 | Re: Worse perfomance on 8.2.0 than on 7.4.14 |
Previous Message | Tom Lane | 2007-01-02 23:09:21 | Re: More 8.2 client issues (Was: [Slow dump?) |