Re: A pessimistic planner

От: Tom Lane
Тема: Re: A pessimistic planner
Дата: ,
(см: обсуждение, исходный текст)
Ответ на: A pessimistic planner  (Stuart Bishop)
Список: pgsql-performance

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 actually useful ... and there are plenty.

We do need to think of ways to account for risk, but I don't think
that jamming the tiller all the way over is likely to be a net

            regards, tom lane

В списке pgsql-performance по дате сообщения:

От: Tom Lane
Сообщение: Re: A pessimistic planner
От: Jeff Janes
Сообщение: Re: Yet another abort-early plan disaster on 9.3