On Fri, 2010-09-10 at 10:37 -0400, Mladen Gogala wrote:
> Euler, optimizer is selecting a wrong path, which is a bug by
I agree that the optimizer should be improved here, but it's not really
a "bug". I think what you are requesting is considered more of a feature
to make the optimizer smarter.
The optimizer will never be so good that it always picks the best path.
Consider a 100-table join: would it be a "bug" if it didn't find the
perfect join order?
In response to
pgsql-bugs by date
|Next:||From: Jeff Davis||Date: 2010-09-10 19:09:10|
|Subject: Re: BUG #5652: Optimizer does wrong thing with partitioned
|Previous:||From: Chris Travers||Date: 2010-09-10 15:10:15|
|Subject: Re: BUG #5652: Optimizer does wrong thing with partitioned tables|