Re: Proposed patch to make mergejoin cost estimation more symmetric

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposed patch to make mergejoin cost estimation more symmetric
Дата
Msg-id 19957.1197040535@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposed patch to make mergejoin cost estimation more symmetric  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-patches
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Yes, but how can you tell by looking at the explain?  I think the point
> is that the "fraction that would be skipped" should be reported somehow.

It is: it's directly reflected in the startup cost.  Previously, a
mergejoin would always have startup cost equal to the sum of its
input startup costs (hence, zero in the cases of interest here).

            regards, tom lane

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Proposed patch to make mergejoin cost estimation more symmetric
Следующее
От: xeb@mail.ru
Дата:
Сообщение: [PATCH] automatic integer conversion