Re: Performance of query (fwd)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance of query (fwd)
Дата
Msg-id 25349.1055385616@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance of query (fwd)  (Edmund Dengler <edmundd@eSentire.com>)
Ответы Re: Performance of query (fwd)  (Edmund Dengler <edmundd@eSentire.com>)
Список pgsql-general
Edmund Dengler <edmundd@eSentire.com> writes:
> Interesting. This brings up a quick question. If a "prepare" statement is
> run, and then values are passed in, does the plan stay the same regardless
> of the values? Or is a second pass made to re-optimize the plan?

AFAICS, the entire *point* of a prepared statement is that the plan is
computed just once for multiple uses.

            regards, tom lane

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

Предыдущее
От: "Maksim Likharev"
Дата:
Сообщение: Re: Postgres performance comments from a MySQL user
Следующее
От: darren@crystalballinc.com
Дата:
Сообщение: Re: createdb for new user?