Re: 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
Дата
Msg-id CA+HiwqHuL+1As6rM3LL+3-v4Yj1QvZmwLhQ5DDcjf60MZqju6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why does row estimation on nested loop make no sense to me  (Jeff Amiel <becauseimjeff@yahoo.com>)
Список pgsql-general
Дерево обсуждения 
On Tue, May 21, 2013 at 12:43 AM, Jeff Amiel <becauseimjeff@yahoo.com> wrote:
> Thanks much!
> (sorry for top-posting, yahoo email sucks)
>

I wonder if you could arrive at some conclusions with the statistics
(pg_stats) you have and the join selectivity formulas described in the
referred documentation link. I would like to know if you still get the
same row  estimates (after explain) and also if possible, the value
that is computed from that formula. Do they resemble each other?


--
Amit Langote

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

Предыдущее
От: Jeff Amiel
Дата:
Сообщение: Re: Why does row estimation on nested loop make no sense to me
Следующее
От: Nicklas Avén
Дата:
Сообщение: Re: cal I pass arguments directly to final function in aggregates