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

Edit
ID 5738
Title Improve hash join's handling of tuples with null join keys
CI (CFBot) Summary
Stats (from CFBot) Patch version: v3, Patch count: 2, First patch: +381−71, All patches: +412−82
Tags Performance
Created 2025-05-05 23:17:11
Last modified 2026-03-03 21:01:15 (yesterday)
Latest email 2026-03-04 07:04:38 (14 hours ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
Target version
Authors Tom Lane (tgl)
Reviewers Chao Li (chaol)Become reviewer
Committer
Links
Emails
Improve hash join's handling of tuples with null join keys
First at 2025-05-05 23:11:54 by Tom Lane <tgl at sss.pgh.pa.us>
Latest at 2026-03-04 07:04:38 by "Joel Jacobson" <joel at compiler.org>
Latest attachment (v3-0001-Improve-hash-join-s-handling-of-tuples-with-null-.patch) at 2026-03-03 20:58:16 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v3-0001-Improve-hash-join-s-handling-of-tuples-with-null-.patch) at 2026-03-03 20:58:16 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Improve-hash-join-s-handling-of-tuples-with-null-.patch) at 2025-06-02 16:47:29 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v1-0001-Improve-hash-join-s-handling-of-tuples-with-null-.patch) at 2025-05-05 23:11:54 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
History
When Who What
2026-03-03 21:01:15 Tom Lane (tgl) New status: Needs review
2026-02-01 00:05:54 Tom Lane (tgl) Moved from CF PG19-4 to CF PG19-Final
2025-12-02 01:29:41 Tom Lane (tgl) Moved from CF PG19-3 to CF PG19-4
2025-10-01 04:52:47 Tom Lane (tgl) Moved from CF PG19-2 to CF PG19-3
2025-08-13 09:16:01 Chao Li (chaol) Posted comment with messageid <175507656113.993.1381684440543440253.pgcf@coridan.postgresql.org>
2025-08-13 09:16:01 Chao Li (chaol) New status: Waiting on Author
2025-08-13 08:59:45 Chao Li (chaol) Added chaol as reviewer
2025-08-01 18:53:56 Tom Lane (tgl) Moved from CF PG19-1 to CF PG19-2
2025-05-05 23:17:12 Tom Lane (tgl) Attached mail thread 3061845.1746486714@sss.pgh.pa.us
2025-05-05 23:17:11 Tom Lane (tgl) Created patch record
Edit