Re: performance of IN (subquery)

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Markus Bertheau <mbertheau(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: performance of IN (subquery)
Date: 2004-08-27 18:13:03
Message-ID: 412F79AF.6060006@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)selectacast(dot)net> wrote:
>
>
>> How does EXECUTE solve the cached-plan business?
>
>
> It re-plans the query at every run.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-27 18:25:05 Re: Strange difference in query execution time
Previous Message Tom Lane 2004-08-27 17:51:00 Re: Stored procedure failure