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 D7A425292C for ; Thu, 9 Jun 2005 15:05:00 -0300 (ADT) 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 80034-08 for ; Thu, 9 Jun 2005 18:04:54 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 897A152863 for ; Thu, 9 Jun 2005 15:04:53 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 283EB152BB; Thu, 9 Jun 2005 13:04:54 -0500 (CDT) Date: Thu, 9 Jun 2005 13:04:53 -0500 From: "Jim C. Nasby" To: Tobias Brox Cc: pgsql-performance@postgresql.org Subject: Re: timestamp indexing Message-ID: <20050609180453.GQ44623@decibel.org> References: <20050530091951.GO26100@tobias.exoweb.net> <20050530135429.GA78082@winnie.fuhr.org> <20050530170816.GA9222@oppetid.no> <24839.1117475874@sss.pgh.pa.us> <20050531020625.GA26100@tobias.exoweb.net> <20050531022011.GC26100@tobias.exoweb.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050531022011.GC26100@tobias.exoweb.net> X-Operating-System: FreeBSD 4.11-RELEASE i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/222 X-Sequence-Number: 12859 What does SET enable_seqscan = false; EXPLAIN ANALYZE SELECT * FROM ... get you? Is it faster? BTW, I suspect this behavior is because the estimates for the cost of an index scan don't give an appropriate weight to the correlation of the index. The 'sort and index' thread on this list from a few months ago has more info. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"