--- On Fri, 12/2/11, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> The only real fix for that will require cross-column
> statistics, which
> we don't have yet --- without such, there's no way for the
> planner to
> know that distributors have an atypical number of child
> customers.
>
I suspected as such.
> At the moment I think the only way to work around this is
> to denormalize
> your schema a bit.
And I feared as much.
It's biting me in other areas as well...this unusual distribution of data...certain types of customers have completely different data patterns than others.
Back to the drawing board...thanks!