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

2025-05-05 Thread Tom Lane
Tomas Vondra writes: > My personal experience is that the growEnabled heuristics is overly > sensitive, and probably does not trigger very often. Yeah, it would be good to make it not quite all-or-nothing. > But more importantly, wasn't the issue discussed in [1] about parallel > hash joins? I'

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

2025-05-05 Thread Tomas Vondra
On 5/6/25 01:11, Tom Lane wrote: > The attached patch is a response to the discussion at [1], where > it emerged that lots of rows with null join keys can send a hash > join into too-many-batches hell, if they are on the outer side > of the join so that they must be null-extended not just discarded