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

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 1, First patch: +381−71, All patches: +381−71

Topic

Performance

Tags

Created

2025-05-05 23:17:11

Last modified

2025-08-01 18:53:56 (1 week ago)

Latest email

2025-08-14 02:36:06 (20 hours ago)

Status

PG19-2 (2025-09-01 - 2025-09-30): Waiting on Author

PG19-1 (2025-07-01 - 2025-07-31): Moved to different CF

Target version

Authors

Tom Lane (tgl)

Reviewers

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 2025-08-14 02:36:06 by Chao Li <li.evan.chao at gmail.com>
Latest 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>
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
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