Re: parameter hints to the optimizer

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: parameter hints to the optimizer
Дата
Msg-id 41155C69.2070407@opencloud.com
обсуждение исходный текст
Ответ на Re: parameter hints to the optimizer  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: parameter hints to the optimizer  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian wrote:
> Oliver Jowett wrote:
> 
>>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.
> 
> 
> What do you mean about arbitrary statements?  Non-prepared ones, or
> non-unnamed ones?

Non-unnamed ones. Adding flag on the Parse message that says when to 
plan the statement (or maybe on each Bind message even).

-O


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Regarding redo/undo files.
Следующее
От: "John Hansen"
Дата:
Сообщение: Re: [PATCHES] UNICODE characters above 0x10000