Re: performance of IN (subquery)

Tom Lane wrote:
> Greg Stark <gsstark@mit.edu> writes:
>
>>I'm not about to run analyze in the middle of the data generation
>>(which wouldn't work anyways since it's in a transaction).
>
>
> Since 7.3 or 7.4, you *can* run ANALYZE in the middle of a transaction.
> The cached-plan business is a problem, I agree, but I think it's
> orthogonal to this particular discussion (and you can always use EXECUTE
> if you have to).
>

  How does EXECUTE solve the cached-plan business?