Re: Was partitioned table row estimation fixed in 9.0?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Was partitioned table row estimation fixed in 9.0?
Дата
Msg-id 11001.1267239609@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Was partitioned table row estimation fixed in 9.0?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> There were a flurry of patches around this from Stark and Aster Data, so
> I'm checking if I should be testing on 9.0 or adding this to the TODO list.

> The problem I'm grappling with is that OUTER JOINS against the master in
> a partitioned table (joining to the append node) gives a row estimate
> which does not take into account any CE applicable to the partitioned
> table.  The CE is properly executed when the join is actually executed,
> but with the row estimate way off (orders of magnitude) you often get
> bad plans for other joins in the query.

Would you give a concrete example?  There was some work done in this
area but it's impossible to tell whether it solves your problem with
only that much detail.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Hot Standby query cancellation and Streaming Replication integration
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: add_path optimization