Re: parameter hints to the optimizer

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: parameter hints to the optimizer
Дата
Msg-id 40FEDA30.2070401@opencloud.com
обсуждение исходный текст
Ответ на parameter hints to the optimizer  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Ответы Re: parameter hints to the optimizer
Список pgsql-hackers
Merlin Moncure wrote:

> Another way to deal with the problem is to defer plan generation until
> the first plan execution and use the parameters from that execution.

When talking the V3 protocol, 7.5 defers plan generation for the unnamed 
statement until parameters are received in the Bind message (which is 
essentially the same as what you describe). There was some discussion at 
the time about making it more flexible so you could apply it to arbitary 
statements, but that needed a protocol change so it didn't happen.

So the guts of the work are done -- we'd just need a way to trigger the 
behaviour on demand. It sounds less painful to add something to PREPARE 
than to change the V3 protocol at this stage.

-O


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: check point segments leakage ?
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: [JDBC] V3 protocol + DECLARE problems