Re: Avoiding bad prepared-statement plans.

Andres Freund wrote:

>> = Actual-cost threshold =
>>
>> Also stop using the generic plan if the statement takes a long time to
>> run in practice. Statistics may have gone bad. It could also be a
>> one-off due to a load peak or something, but that's handled by:

> That is not that easy. It means that you have to use savepoints enclosing each
> and every execution of a prepared statement because the query could have
> sideeffects. Which wouldnt be terribly efficient...

This is not within an execution of the statement, but across executions.
So the next execution learns from the previous result. So I'm not
talking about aborting the ongoing execution. Sorry for being unclear.

Jeroen