X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 36CB1CD6CB for ; Fri, 11 Jul 2003 19:43:49 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 82886-04 for ; Fri, 11 Jul 2003 19:44:04 +0000 (GMT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 646D6CBAB8 for ; Fri, 11 Jul 2003 12:23:56 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6BFO1Q3011920; Fri, 11 Jul 2003 11:24:01 -0400 (EDT) To: Scott Cain Cc: pgsql-performance@postgresql.org Subject: Re: force the use of a particular index In-reply-to: <1057850280.1451.22.camel@localhost.localdomain> References: <1057850280.1451.22.camel@localhost.localdomain> Comments: In-reply-to Scott Cain message dated "10 Jul 2003 11:18:01 -0400" Date: Fri, 11 Jul 2003 11:24:01 -0400 Message-ID: <11919.1057937041@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/181 X-Sequence-Number: 2474 Scott Cain writes: > So, the question is, is there a way I can force the query planner to use > the index I want it to use? No (and I don't think there should be). Given that it *can* generate the plan you want, this is clearly an estimation failure. What is the index it does use? Would you show us EXPLAIN ANALYZE results when using each index? regards, tom lane