Re: Oddball data distribution giving me planner headaches - Mailing list pgsql-general

From Jeff Amiel
Subject Re: Oddball data distribution giving me planner headaches
Date
Msg-id 1322864568.39918.YahooMailClassic@web65505.mail.ac4.yahoo.com
Whole thread Raw
In response to Re: Oddball data distribution giving me planner headaches  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

--- 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!



pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Re: Oddball data distribution giving me planner headaches
Next
From: "Ing.Edmundo.Robles.Lopez"
Date:
Subject: weird negative seconds on checkpoint message.