Re: Why does row estimation on nested loop make no sense to me

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why does row estimation on nested loop make no sense to me
Дата
Msg-id 26056.1368808522@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Why does row estimation on nested loop make no sense to me  (Jeff Amiel <becauseimjeff@yahoo.com>)
Ответы Re: Why does row estimation on nested loop make no sense to me  (Jeff Amiel <becauseimjeff@yahoo.com>)
Список pgsql-general
Дерево обсуждения 
Jeff Amiel <becauseimjeff@yahoo.com> writes:
> How can the estimated number of rows for the nested loop node EXCEED the product of the 2 row estimates of the tables
beingjoined? 
> Not only does it exceed it - but it is orders of magnitude greater.

Can you provide a self-contained test case that does this?

            regards, tom lane

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

Предыдущее
От: Jeff Amiel
Дата:
Сообщение: Why does row estimation on nested loop make no sense to me
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Why does row estimation on nested loop make no sense to me