--- On Fri, 12/2/11, Tom Lane <t...@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 different data patterns than 
others.  
Back to the drawing board...thanks!



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to