Re: parameter hints to the optimizer

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: parameter hints to the optimizer
Дата
Msg-id 200408080010.i780A7l22395@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: parameter hints to the optimizer  (Oliver Jowett <oliver@opencloud.com>)
Ответы Re: parameter hints to the optimizer  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-hackers
Oliver Jowett wrote:
> 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).

OK, what are unnamed prepared statements?  When are they used currently?
Only via the wire protocol?  Who uses them now?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

Предыдущее
От: "John Hansen"
Дата:
Сообщение: Re: UNICODE characters above 0x10000
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: [PATCHES] UNICODE characters above 0x10000