Re: parametrized statements, but always replan?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: parametrized statements, but always replan?
Дата
Msg-id 14091.1166679742@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: parametrized statements, but always replan?  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
Dave Cramer <pg@fastcrypt.com> writes:
> The only time prepared statements won't replan is if you re-use the
> prepared statement, which your code does not.
> However... AFAIK, postgresql does not plan based on the parameter.

This was changed in 8.2: for an unnamed statement the planning step is
delayed until Bind time, so that the actual parameter values can be
considered.

            regards, tom lane

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

Предыдущее
От: Kevin Murphy
Дата:
Сообщение: State of the art in large scale inserts
Следующее
От: Didier BRETIN
Дата:
Сообщение: ant specif task for pg_dump and pg_restore