Re: nested loop semijoin estimates

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: nested loop semijoin estimates
Дата
Msg-id 3510.1433273963@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: nested loop semijoin estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: nested loop semijoin estimates
Список pgsql-hackers
I wrote:
> I'm a bit disturbed by that, because AFAICS from the plans, these queries
> did not involve any semi or anti joins, which should mean that the patch
> would not have changed the planner's behavior.

After contemplating my navel for awhile, it occurred to me that maybe the
patch's changes in add_path_precheck could have caused behavioral changes
at the margins.  Could you try a run without that (without the last two
hunks in pathnode.c)?
        regards, tom lane



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: nested loop semijoin estimates
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: nested loop semijoin estimates