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 4974F5282B for ; Mon, 27 Jun 2005 19:27:04 -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 19891-10 for ; Mon, 27 Jun 2005 22:26:55 +0000 (GMT) Received: from mail24.sea5.speakeasy.net (mail24.sea5.speakeasy.net [69.17.117.26]) by svr1.postgresql.org (Postfix) with ESMTP id 9453652828 for ; Mon, 27 Jun 2005 19:26:54 -0300 (ADT) Received: (qmail 28912 invoked from network); 27 Jun 2005 22:26:57 -0000 Received: from dsl093-114-095.chi2.dsl.speakeasy.net (HELO mofo.meme.com) ([66.93.114.95]) (envelope-sender ) by mail24.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 27 Jun 2005 22:26:57 -0000 Received: from mofo (localhost.localdomain [127.0.0.1]) by mofo.meme.com (Postfix) with ESMTP id 1C46B6E421 for ; Mon, 27 Jun 2005 18:16:01 -0500 (CDT) Date: Mon, 27 Jun 2005 23:16:01 +0000 From: "Karl O. Pinc" Subject: Forcing use of a particular index To: pgsql-performance@postgresql.org X-Mailer: Balsa 2.3.0 Message-Id: <1119914161l.4428l.4l@mofo> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; DelSp=Yes; Format=Flowed Content-Disposition: inline Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/505 X-Sequence-Number: 13142 http://www.postgresql.org/docs/8.0/static/indexes-examine.html Says: "If you do not succeed in adjusting the costs to be more appropriate, then you may have to resort to forcing index usage explicitly." Is there a way to force a query to use a particular index? If not, what does this sentence mean? Thanks. Karl Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein