Re: Forcing use of specific index - Mailing list pgsql-performance

From Qingqing Zhou
Subject Re: Forcing use of specific index
Date
Msg-id d7sd3s$1qc3$1@news.hub.org
Whole thread Raw
In response to Forcing use of specific index  (Tobias Brox <tobias@nordicbet.com>)
List pgsql-performance
"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



pgsql-performance by date:

Previous
From: Mischa Sandberg
Date:
Subject: Re: Best hardware
Next
From: Bill Ewing
Date:
Subject: Re: Need help to decide Mysql vs Postgres