Tom Lane wrote:
Could be. I went back to look at Sam Mason's report about three weeks
ago, and it definitely seems to explain his issue.
I've just built a patched version as well and it appears to be doing
what I think is the right thing now. I.e. actually picking the
plan with the lower cost.
On Fri, 2005-07-22 at 12:20 -0400, Tom Lane wrote:
I think that this refutes the original scheme of using the same fuzz
factor for both startup and total cost comparisons, and therefore
propose the attached patch.
Comments?
Looks good. I think it explains a few other wierd perf reports
Simon Riggs [EMAIL PROTECTED] writes:
Looks good. I think it explains a few other wierd perf reports also.
Could be. I went back to look at Sam Mason's report about three weeks
ago, and it definitely seems to explain his issue. The fuzzy cost
comparison logic is new in 8.0 so it hasn't had all