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 743A23A1968 for ; Fri, 31 Dec 2004 05:57:38 +0000 (GMT) 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 34142-02 for ; Fri, 31 Dec 2004 05:57:25 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id A79E03A197E for ; Fri, 31 Dec 2004 05:57:24 +0000 (GMT) Received: (qmail 18473 invoked by uid 500); 31 Dec 2004 06:10:42 -0000 Date: Fri, 31 Dec 2004 00:10:42 -0600 From: Bruno Wolff III To: Karl Vogel Cc: Yann Michel , pgsql-performance@postgresql.org Subject: Re: Why so much time difference with a same query/plan? Message-ID: <20041231061042.GA17555@wolff.to> Mail-Followup-To: Karl Vogel , Yann Michel , pgsql-performance@postgresql.org References: <20041222200904.94015.qmail@web13124.mail.yahoo.com> <20041222215240.12345.qmail@web13124.mail.yahoo.com> <20041223070453.GA30031@zong.spline.inf.fu-berlin.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/315 X-Sequence-Number: 9690 On Sun, Dec 26, 2004 at 13:30:15 +0100, Karl Vogel wrote: > > This depends on the version of Oracle you're using. Oracle 9i > introduced Index Skip Scans: > > http://www.oracle.com/technology//products/oracle9i/daily/apr22.html > > I don't know whether pg has something similar? Postgres doesn't currently do this. There was some discussion about this not too long ago, but I don't think anyone indicated that they were going to work on it for 8.1. Postgres can use the leading part of a multikey index to start a scan, but it will just do a normal index scan with a filter.