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 A0DDE5282B
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat,  4 Jun 2005 11:16:41 -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 55145-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat,  4 Jun 2005 14:16:31 +0000 (GMT)
Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 97C2E52805
	for <pgsql-performance@postgresql.org>;
	Sat,  4 Jun 2005 11:16:30 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 97EE430952; Sat,  4 Jun 2005 16:12:58 +0200 (MET DST)
From: "Qingqing Zhou" <zhouqq@cs.toronto.edu>
X-Newsgroups: pgsql.performance
Subject: Re: Forcing use of specific index
Date: Sat, 4 Jun 2005 22:14:26 +0800
Organization: Hub.Org Networking Services
Lines: 12
Message-ID: <d7sd3s$1qc3$1@news.hub.org>
References: <20050602020528.GL26100@tobias.exoweb.net>
Reply-To: "Qingqing Zhou" <zhouqq@cs.toronto.edu>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
To: pgsql-performance@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.195 tagged_above=0 required=5 tests=AWL,
	PRIORITY_NO_NAME
X-Spam-Level: *
X-Archive-Number: 200506/94
X-Sequence-Number: 12732

"Tobias Brox" <tobias@nordicbet.com> writes
> Is it any way to attempt to force the planner to use some specific index
> while creating the plan?  Other than eventually dropping all the other
> indices (which is obiously not a solution in production setting anyway)?
>

I don't think currently PG supports this but "SQL hints" is planned ...

Regards,
Qingqing