Re: force the use of a particular index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Cain <cain(at)cshl(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: force the use of a particular index
Date: 2003-07-11 15:24:01
Message-ID: 11919.1057937041@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Cain <cain(at)cshl(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Cain 2003-07-11 15:36:19 Re: force the use of a particular index
Previous Message Rod Taylor 2003-07-11 13:38:16 Re: force the use of a particular index