Re: Estimation issue with partitioned tables

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Estimation issue with partitioned tables
Дата
Msg-id 603c8f071003031807p52f136edh683d19a1d5b46660@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Estimation issue with partitioned tables  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Estimation issue with partitioned tables  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Estimation issue with partitioned tables
Следующее
От: Robert Haas
Дата:
Сообщение: Re: partition pruning