Re: [HACKERS] Wrong index choosen?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: [HACKERS] Wrong index choosen?
Дата
Msg-id 1090620173.709.66.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: [HACKERS] Wrong index choosen?  (Jaime Casanova <systemguards@yahoo.com>)
Список 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.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: [HACKERS] Wrong index choosen?
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: [HACKERS] Wrong index choosen?