On Fri, 2007-09-21 at 12:08 -0400, Tom Lane wrote:
> Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
> > Looking at Plan 2, it looks like the "limit" step is estimating wrongly
> > it's cost.
> The reason you get a bad plan is that this rowcount estimate is so far
That's true, but its not relevant, since the query would still be fast
even if that estimate was exactly right. With LIMIT 10, it wouldn't
matter how many rows were there as long as there were more than 10. The
true execution cost is limited, the cost model is not.
In response to
pgsql-performance by date
|Next:||From: Simon Riggs||Date: 2007-09-21 17:49:33|
|Subject: Re: Query planner unaware of possibly best plan|
|Previous:||From: brauagustin-susc||Date: 2007-09-21 17:30:45|
|Subject: Re: Low CPU Usage|