Re: Irrelevant columns cause massive performance change

2018-03-16 Thread Craig James
On Fri, Mar 16, 2018 at 1:50 PM, Andres Freund wrote: > Hi, > > On 2018-03-16 13:37:05 -0700, Craig James wrote: > > The timing of the second query is excellent, and is what I expected. I > > don't understand why including a function-defined column in the view > would > > have such a dramatic eff

Re: Irrelevant columns cause massive performance change

2018-03-16 Thread Andres Freund
Hi, On 2018-03-16 13:37:05 -0700, Craig James wrote: > The timing of the second query is excellent, and is what I expected. I > don't understand why including a function-defined column in the view would > have such a dramatic effect on the planner's ability to choose the sdf_pkey > index for the j