Re: Oddball data distribution giving me planner headaches

--- On Fri, 12/2/11, David Johnston <polobo(at)yahoo(dot)com> wrote:

> From: David Johnston <polobo(at)yahoo(dot)com>

> ---------------------------------------------------------
> My, possibly naïve, observation:
>
> So aside from the fact the estimates seem to be off the
> planner has still
> chosen the most effective plan?  In that situation no
> matter how accurate
> you get the statistics you will not gain any performance
> because the planner
> will never choose a different plan.
>
Thanks.....
I'm not interested in optimizing this query.....it's fast and efficient. However, the planner thinks that it is going to return a million rows when it is only going to return one thousand. When this query is used as an element of a BIGGER query, that causes me all sorts of planner issues....
That's the problem I am trying to solve...why the planner is 3 orders of magnitude off in row estimation.