Tom Lane wrote:
Lukas Kahwe Smith <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate