Re: performance of IN (subquery) - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: performance of IN (subquery)
Date
Msg-id 412F79AF.6060006@selectacast.net
Whole thread Raw
In response to performance of IN (subquery)  (Kevin Murphy <murphy@genome.chop.edu>)
Responses Re: performance of IN (subquery)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stored procedure failure
Next
From: Tom Lane
Date:
Subject: Re: Strange difference in query execution time