Re: [PERFORM] views much slower in 9.3 than 8.4

2015-03-30 Thread Tom Lane
Kevin Grittner writes: > Tom Lane wrote: >> But the other problem is that the planner considers less-than-1% >> differences in cost estimates to be "in the noise", which means >> that it's not going to consider cost differences of less than >> 1480 units in the remaining join steps to be signific

Re: [PERFORM] views much slower in 9.3 than 8.4

2015-03-30 Thread Kevin Grittner
Tom Lane wrote: > But the other problem is that the planner considers less-than-1% > differences in cost estimates to be "in the noise", which means > that it's not going to consider cost differences of less than > 1480 units in the remaining join steps to be significant. This > is how come we e