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

In response to

• Re: Avoiding bad prepared-statement plans. at 2010-02-09 14:10:22 from Andres Freund

pgsql-hackers by date

Next:	From: Federico Di Gregorio	Date: 2010-02-09 14:28:38
	Subject: Re: About psycopg2 (by its author)
Previous:	From: Jeroen Vermeulen	Date: 2010-02-09 14:25:19
	Subject: Re: Avoiding bad prepared-statement plans.