Re: Avoiding bad prepared-statement plans.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Avoiding bad prepared-statement plans.
Дата
Msg-id 603c8f071002260850r19c2c9e4gcea15621b653ae92@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Avoiding bad prepared-statement plans.  (Alex Hunsaker <badalex@gmail.com>)
Ответы Re: Avoiding bad prepared-statement plans.  (Alex Hunsaker <badalex@gmail.com>)
Список pgsql-hackers
On Fri, Feb 26, 2010 at 1:29 AM, Alex Hunsaker <badalex@gmail.com> wrote:
> Prepared plans + exec plan (new guc/ protocol thing):
>  Use: not quite sure
>  Problems: slow because it would replan every time
>  Solutions: use a prepared plan with the appropriate things not
> parametrized...?
>
> [ aka we already have this, its called dont use a prepared statement ]

The point is sometimes you'd like to replan every time, but not
reparse every time.  There's no way to do that ATM.

...Robert


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Hot Standby query cancellation and Streaming Replication integration
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Avoiding bad prepared-statement plans.