Re: Measuring the Query Optimizer Effect: Turning off the QO?

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Measuring the Query Optimizer Effect: Turning off the QO?
Дата
Msg-id 875zoc7h29.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Measuring the Query Optimizer Effect: Turning off the QO?  (Tom Mercha <mercha_t@hotmail.com>)
Ответы Re: Measuring the Query Optimizer Effect: Turning off the QO?  (Tom Mercha <mercha_t@hotmail.com>)
Список pgsql-general
>>>>> "Tom" == Tom Mercha <mercha_t@hotmail.com> writes:

 Tom> Hi All

 Tom> As we know, a query goes through number of stages before it is
 Tom> executed. One of these stages is query optimization (QO).

That's not really true at all. One of the stages is query _planning_,
which takes the (rewritten) query as input and converts it to something
that the executor can take action on. There isn't actually any separate
"optimization" phase.

-- 
Andrew (irc:RhodiumToad)



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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Incremental aggregate/rollup strategy advice
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: Measuring the Query Optimizer Effect: Turning off the QO?