Tom Lane wrote:

> Bug #19030 [1] seems to be a fresh report of the problem this patch
> aims to solve.  

> [1] 
> https://www.postgresql.org/message-id/flat/19030-944dd78d7ef94c0f%40postgresql.org
> 

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.

regards
Marc-Olaf Jaschke

Reply via email to