Re: BUG #14404: High row estimates when query uses master inherited tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #14404: High row estimates when query uses master inherited tables
Дата
Msg-id 29426.1477704022@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #14404: High row estimates when query uses master inherited tables  (clinton.adams@gmail.com)
Ответы Re: BUG #14404: High row estimates when query uses master inherited tables  (Clinton Adams <clinton.adams@gmail.com>)
Список pgsql-bugs
clinton.adams@gmail.com writes:
> Row estimates are way off (406484054678631 vs 38) when using master
> partition tables. If I change the query to go directly against one child
> table, estimates and query time are in line with what I expect.

Those EXPLAINs do look kinda fishy, but with only this much information,
it's unlikely that anyone is going to be able to guess why.  A
self-contained example would be much more useful.

            regards, tom lane

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

Предыдущее
От: clinton.adams@gmail.com
Дата:
Сообщение: BUG #14404: High row estimates when query uses master inherited tables
Следующее
От: dv
Дата:
Сообщение: ORDER BY TABLENAME, possible bug