Re: Automatic function replanning

Bruce Momjian wrote:

>     * Flush cached query plans when the dependent objects change,
>       when the cardinality of parameters changes dramatically, or
>       when new ANALYZE statistics are available

Wouldn't it also make sense to flush a cached query plan when after 
execution it is determined that one or more assumptions that the cached 
query plan was based on was found to be off? Like the query plan was 
based on the assumption that a particular table would only return a hand 
full of rows, but in reality it returned a few thousand.

regards,
Lukas