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

From Joseph Shraibman
Subject Re: performance of IN (subquery)
Date
Msg-id 412F4EA6.1070302@selectacast.net
Whole thread Raw
In response to Re: performance of IN (subquery)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: performance of IN (subquery)  (Markus Bertheau <mbertheau@gmail.com>)
List pgsql-general

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?

pgsql-general by date:

Previous
From: Jeremy Jongsma
Date:
Subject: Strange difference in query execution time
Next
From: Jeff Amiel
Date:
Subject: upgrading minor versions