Re: Estimation issue with partitioned tables - Mailing list pgsql-performance

From Robert Haas
Subject Re: Estimation issue with partitioned tables
Date
Msg-id 603c8f071003031807p52f136edh683d19a1d5b46660@mail.gmail.com
Whole thread Raw
In response to Re: Estimation issue with partitioned tables  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Estimation issue with partitioned tables  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Wed, Mar 3, 2010 at 4:45 PM, Josh Berkus <josh@agliodbs.com> wrote:
>> I feel like I've seen these way-too-high row estimates in some other
>> postings to -performance, but I'm not sure if it was the same issue.
>> You don't by chance have a RTC? I don't think it's likely fixed in 9.0
>> but it would be interesting to investigate.
>
> Yeah, I can generate one pretty easily; the behavior is readily
> observable and repeatable.  Will get on it RSN, but at you said, we're
> not doing anything about it for 9.0.
>
> I've a feeling that this will become one of the list of issues to be
> fixed with 'real partitioning'.

I can believe it.  I can't promise anything, but like I say I'm
willing to take a poke at it if you can provide me a test case.

...Robert

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Estimation issue with partitioned tables
Next
From: Robert Haas
Date:
Subject: Re: partition pruning