Re: performance of IN (subquery)

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: performance of IN (subquery)
Дата
Msg-id 412F79AF.6060006@selectacast.net
обсуждение исходный текст
Ответ на performance of IN (subquery)  (Kevin Murphy <murphy@genome.chop.edu>)
Ответы Re: performance of IN (subquery)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
According to the docs is specifically doesn't.

http://www.postgresql.org/docs/7.4/static/sql-prepare.html

When the PREPARE statement is executed, the specified statement is
parsed, rewritten, and planned. When an EXECUTE command is subsequently
issued, the prepared statement need only be executed. Thus, the parsing,
rewriting, and planning stages are only performed once, instead of every
time the statement is executed.



Markus Bertheau wrote:
> On Fri, 27 Aug 2004 11:09:26 -0400, Joseph Shraibman
> <jks@selectacast.net> wrote:
>
>
>>  How does EXECUTE solve the cached-plan business?
>
>
> It re-plans the query at every run.
>

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Stored procedure failure
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange difference in query execution time