Re: Plan invalidation design

Tom Lane wrote:
> Lukas Kahwe Smith <smith(at)pooteeweet(dot)org> writes:
>> I remember that there was discussion about invalidating plans who's
>> estimated cost turn out to be severely off when executed.
>
> That's something we might think about after the infrastructure is in
> place. But the question to answer is why the re-plan won't yield
> just the same plan as before.

Yeah, also invalidating plans like this only really makes sense once we
have the ability to keep multiple plans around for different sets of
parameters. Otherwise we could also end up in a situation where after
every execution we determine that a re-plan is necessary because the
parameters used differ in distribution.

regards,
Lukas