pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Rolf Østvik <rolfostvik@yahoo.no>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Worse perfomance on 8.2.0 than on 7.4.14
Date: Wed, 3 Jan 2007 09:01:37 +0100 (CET)
Message-ID: <22580.68259.qm@web26303.mail.ukl.yahoo.com> (raw)
In-Reply-To: <3425.1167750444@sss.pgh.pa.us>
--- 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
view thread (17+ messages) latest in thread
Message-ID: <22580.68259.qm@web26303.mail.ukl.yahoo.com> Permalink: ../22580.68259.qm@web26303.mail.ukl.yahoo.com/ Also on: postgresql.org/message-id/22580.68259.qm@web26303.mail.ukl.yahoo.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-performance@postgresql.org Cc: rolfostvik@yahoo.no, tgl@sss.pgh.pa.us Subject: Re: Worse perfomance on 8.2.0 than on 7.4.14 In-Reply-To: <22580.68259.qm@web26303.mail.ukl.yahoo.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox