Re: Forcing use of specific index

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Forcing use of specific index
Date: 2005-06-04 14:14:26
Message-ID: d7sd3s$1qc3$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Tobias Brox" <tobias(at)nordicbet(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mischa Sandberg 2005-06-04 23:23:37 Re: Best hardware
Previous Message Bernd Jagla 2005-06-04 13:30:57 Best hardware