Stuart Bishop writes:
> I was wondering if the planner should be much more pessimistic,
> trusting in Murphy's Law and assuming the worst case is the likely
> case? Would this give me a much more consistent system?
Well, it would give uniformly awful plans for cases where fast-start
plans are act
Another day, another timing out query rewritten to force a more stable
query plan.
While I know that the planner almost always chooses a good plan, I
tend to think it is trying too hard. While 99% of the queries might be
10% faster, 1% might be timing out which makes my users cross and my
life dif
