Re: performance of IN (subquery)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: Markus Bertheau <mbertheau(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: performance of IN (subquery)
Date: 2004-08-27 18:43:45
Message-ID: 1430.1093632225@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joseph Shraibman <jks(at)selectacast(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2004-08-27 19:19:03 Re: performance of IN (subquery)
Previous Message borajetta 2004-08-27 18:40:53 Which Order Vacuum Full Analyze Cluster Reindex?