Tom Lane wrote:
Greg Stark <[EMAIL PROTECTED]> 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?
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]