X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 367AD32BD1F for ; Tue, 12 Oct 2004 15:41:09 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40863-01 for ; Tue, 12 Oct 2004 14:40:55 +0000 (GMT) Received: from trofast.sesse.net (trofast.sesse.net [129.241.93.32]) by svr1.postgresql.org (Postfix) with ESMTP id A849832B1DF for ; Tue, 12 Oct 2004 15:40:56 +0100 (BST) Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1CHNpe-00027y-00 for ; Tue, 12 Oct 2004 16:40:54 +0200 Date: Tue, 12 Oct 2004 16:40:54 +0200 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: Normal case or bad query plan? Message-ID: <20041012144054.GA8166@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <41536BE0000113F4@ims3d.cp.tin.it> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41536BE0000113F4@ims3d.cp.tin.it> X-Operating-System: Linux 2.6.6 on a i686 User-Agent: Mutt/1.5.6+20040818i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/165 X-Sequence-Number: 8641 On Tue, Oct 12, 2004 at 04:29:36PM +0200, Gabriele Bartolini wrote: > FYI I set it to 1000 (the maximum) and I reduced the query's estimated time > by the 90% (from 40000ms to 4000ms) although much slower than the index > scan (200ms). Note that the estimated times are _not_ in ms. They are in multiples of a disk fetch (?). Thus, you can't compare estimated and real times like that. /* Steinar */ -- Homepage: http://www.sesse.net/