Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: performance of IN (subquery)
Date
Msg-id 1430.1093632225@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance of IN (subquery)  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Tree view 
Joseph Shraibman <jks@selectacast.net> writes:
> Markus Bertheau wrote:
>> It re-plans the query at every run.

> According to the docs is specifically doesn't.

You're confusing SQL EXECUTE statement with the quite different plpgsql
EXECUTE statement ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange difference in query execution time
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: performance of IN (subquery)