Re: Prepared statements considered harmful

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Prepared statements considered harmful
Дата
Msg-id 20060901064242.GC12644@svana.org
обсуждение исходный текст
Ответ на Re: Prepared statements considered harmful  (Gregory Stark <gsstark@mit.edu>)
Ответы Re: Prepared statements considered harmful
Re: Prepared statements considered harmful
Список pgsql-hackers
On Thu, Aug 31, 2006 at 07:04:07PM -0400, Gregory Stark wrote:
> The server has to prepare the query sometime. The v3 protocol just gives you
> control over when that happens, but it doesn't force you to do it at any
> particular time.

Not really. All named prepares are planned straight away, all unnamed
ones are planned at bind time. Therefore you cannot have more than one
parsed-but-not-planned prepared query at a time. In a connection pool
scenario there's no way to share such plans since you can't tell which
query has been prepared. That's not forcing, but it's an asymmetry we
could do with out.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Roadmaps 'n all that
Следующее
От: Lukas Kahwe Smith
Дата:
Сообщение: Re: Prepared statements considered harmful