X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CA980D1B4FE for ; Fri, 19 Sep 2003 10:43:24 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 11734-05 for ; Fri, 19 Sep 2003 07:42:55 -0300 (ADT) Received: from wight.ymogen.net (unknown [217.27.240.153]) by svr1.postgresql.org (Postfix) with SMTP id E9C5DD1B4F6 for ; Fri, 19 Sep 2003 07:42:51 -0300 (ADT) Received: (qmail 11089 invoked from network); 19 Sep 2003 10:42:49 -0000 Received: from host213-123-217-162.in-addr.btopenworld.com (HELO solent) (213.123.217.162) by wight.ymogen.net with SMTP; 19 Sep 2003 10:42:49 -0000 From: "Matt Clark" To: "Jenny Zhang" , Cc: "perf-pgsql" Subject: Re: osdl-dbt3 run results - puzzled by the execution Date: Fri, 19 Sep 2003 11:41:55 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal In-Reply-To: <1063932761.31150.90.camel@ibm-a.pdx.osdl.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/283 X-Sequence-Number: 3649 > I put the EXPLAIN ANALYZE output at: > http://developer.osdl.org/~jenny/large_explain_analyze > http://developer.osdl.org/~jenny/small_explain_analyze > The actual execution time is 37 seconds(large) vs 5 seconds (small). > There's an obvious row count misestimation in the 'large' plan: -> Sort (cost=519.60..520.60 rows=400 width=31) (actual time=106.88..143.49 rows=30321 loops=1) but I'm not good enough at reading these things to tell if that's the cause of the problem, or if so how to fix it :-(