Re: Improving worst-case merge join performance with often-null foreign key

2023-04-26 Thread Steinar Kaldager
On Sun, Apr 23, 2023 at 11:30 AM Richard Guo wrote: > On Sat, Apr 22, 2023 at 11:21 PM Tom Lane wrote: >> Hmm. I don't entirely understand why the existing stop-at-nulls logic >> in nodeMergejoin.c didn't fix this for you. Maybe somebody has broken >> that? See the commentary for MJEvalOuterVa

Improving worst-case merge join performance with often-null foreign key

2023-04-22 Thread Steinar Kaldager
he query already, adding another is just messy. (4) Should this sort of thing be made conditional on a high null_frac? Or is that unnecessary complexity, and the simplicity of just always doing it would be better? Thanks! Steinar Kaldager