On 3/30/15 10:52 AM, Tom Lane wrote:
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
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
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
I wrote:
> "Carson, Leonard" writes:
>> Here are the 3 views and some timing notes:
>> http://pgsql.privatepaste.com/decae31693#
> That doesn't really leave us any wiser than before, unfortunately.
> It's clear that the root of the problem is the drastic underestimation of
> the size of the rq/a
"Carson, Leonard" writes:
> Here are the 3 views and some timing notes:
> http://pgsql.privatepaste.com/decae31693#
That doesn't really leave us any wiser than before, unfortunately.
It's clear that the root of the problem is the drastic underestimation of
the size of the rq/a join, but it's not
Here are the 3 views and some timing notes:
http://pgsql.privatepaste.com/decae31693#
thanks, lcarson
On Mar 18, 2015, at 3:41 PM, Tom Lane
mailto:t...@sss.pgh.pa.us>> wrote:
"Carson, Leonard" mailto:lcar...@sdsc.edu>> writes:
There is only one server at this point. The 8.4 machine was upgraded
"Carson, Leonard" wrote:
> While acknowledging that nested loops and sequential table scans
> account for 85% of the execution time which suggests that a
> better query may be needed, why would the same query run in
> seconds on 8.x but take minutes on 9.x?
First, please show the output of this
