Re: Improve hash join's handling of tuples with null join keys

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Improve hash join's handling of tuples with null join keys
Дата
Msg-id 470075.1756063113@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Improve hash join's handling of tuples with null join keys  (Marc-Olaf Jaschke <moj@dshare.de>)
Список pgsql-hackers
Marc-Olaf Jaschke <moj@dshare.de> writes:
> I can confirm that the patch fixes the issue (Bug #19030). The memory usage remains within the expected range of
work_mem.
> This also applies to parallel hash joins.
> The query also runs significantly faster.
> I also tested cases with multiple left joins.
> I have only observed this problem when there are many null values in the join column.

Thanks for testing!

            regards, tom lane



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