Re: A pessimistic planner - Mailing list pgsql-performance

From Tom Lane
Subject Re: A pessimistic planner
Date
Msg-id 21114.1416546725@sss.pgh.pa.us
Whole thread Raw
In response to A pessimistic planner  (Stuart Bishop <stuart@stuartbishop.net>)
List pgsql-performance
Stuart Bishop <stuart@stuartbishop.net> 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
improvement.

            regards, tom lane


pgsql-performance by date:

Previous
From: Stuart Bishop
Date:
Subject: A pessimistic planner
Next
From: Jeff Janes
Date:
Subject: Re: Yet another abort-early plan disaster on 9.3