Re: Oddball data distribution giving me planner headaches

--- On Fri, 12/2/11, Tom Lane <tgl@sss.pgh.pa.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
differentdata patterns than others.   
Back to the drawing board...thanks!