Re: force the use of a particular index - Mailing list pgsql-performance

From Tom Lane
Subject Re: force the use of a particular index
Date
Msg-id 11919.1057937041@sss.pgh.pa.us
Whole thread Raw
In response to force the use of a particular index  (Scott Cain <cain@cshl.org>)
Responses Re: force the use of a particular index  (Scott Cain <cain@cshl.org>)
List pgsql-performance
Scott Cain <cain@cshl.org> 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

pgsql-performance by date:

Previous
From: Martin Foster
Date:
Subject: Re: [NOVICE] Extreme high load averages
Next
From: Scott Cain
Date:
Subject: Re: force the use of a particular index