Re: Index Tuning Features

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: Index Tuning Features
Дата
Msg-id E1539E0ED7043848906A8FF995BDA579016A057C@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: Index Tuning Features  ("Jaime Casanova" <systemguards@gmail.com>)
Список pgsql-hackers
> > Another thing that this brings up is "hints" to a query. Over the
> > years, I have run into situation where the planner wasn't
> great.  It
> > would be nice to try forcing different strategies on the
> planner and
> > see if performance caan be improved.
> >
>
> you can do this by setting enable_"access_method" type parameters.

No, not generally. Usual problems include join order and wrong index,
not only wrong access method.

Andreas


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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: Clarification needed
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Index Tuning Features