Re: Overriding the optimizer

Поиск
Список
Период
Сортировка
От Craig A. James
Тема Re: Overriding the optimizer
Дата
Msg-id 43A22EA3.50007@modgraph-usa.com
обсуждение исходный текст
Ответ на Re: Overriding the optimizer  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane wrote:
> This discussion has been had before (many times) ... see the -hackers
> archives for detailed arguments.  The one that carries the most weight
> in my mind is that planner hints embedded in applications will not adapt
> to changing circumstances --- the plan that was best when you designed
> the code might not be best today.

Absolutely right.  But what am I supposed to do *today* if the planner makes a mistake?  Shut down my web site?

Ropes are useful, but you can hang yourself with them.  Knives are useful, but you can cut yourself with them.  Should
weban useful tools because they cause harm to the careless? 

Craig

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

Предыдущее
От: "Craig A. James"
Дата:
Сообщение: Re: Overriding the optimizer
Следующее
От: "Craig A. James"
Дата:
Сообщение: Re: Overriding the optimizer