| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | "Jaime Casanova" <systemguards(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Wrong index choosen? |
| Date: | 2004-07-23 22:02:53 |
| Message-ID: | 1090620173.709.66.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Fri, 2004-07-23 at 15:51, Jaime Casanova wrote:
> Hi all,
>
> just as a question.
>
> There will be some day a feature that let you force
> the planner to use an specific index, like oracle
> does?
>
> Of course the planner is smart enough most times but
> sometimes such an option would be usefull, don't you
> think so?
A planner that always made the right choice would be the most useful
thing. After that, the ability to "push" the planner towards an index
would be pretty nice.
Adding features that make PostgreSQL more error prone (i.e. forcing
particular index usage, etc.) and harder to drive but allow an expert to
get what they want is kind of a dangerous road to tread.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Browne | 2004-07-23 22:21:17 | Re: [HACKERS] Tutorial |
| Previous Message | Jaime Casanova | 2004-07-23 21:51:11 | Re: [HACKERS] Wrong index choosen? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2004-07-24 00:07:27 | Re: [HACKERS] Wrong index choosen? |
| Previous Message | Jaime Casanova | 2004-07-23 21:51:11 | Re: [HACKERS] Wrong index choosen? |