Re: parameter hints to the optimizer

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: parameter hints to the optimizer
Дата
Msg-id 200408070141.i771fQp05906@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:
> 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?

I am trying to figure out what TODO item needs to be added.

--  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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: CVS comment
Следующее
От: Joe Conway
Дата:
Сообщение: Re: [PATCHES] [BUGS] casting strings to multidimensional arrays yields