David Rowley <dgrowleyml@gmail.com> writes:
> On Mon, Jul 14, 2014 at 3:00 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Ugh. I'm back to being discouraged about the usefulness of the
>> optimization.
> Are you worried about the planning overhead of the not null checks, or is
> it more that you think there's a much smaller chance of a real world
> situation that the optimisation will succeed?
Both. We need to look at how much it costs the planner to run these
checks, and think about how many real queries it will help for. The
first is quantifiable, the second probably not so much :-( but we still
need to ask the question.
regards, tom lane