Reduce outer joins in more cases

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v1, Patch count: 1, First patch: +45−71, All patches: +45−71

Tags

Performance

Created

2026-06-15 09:25:47

Last modified

2026-08-21 07:24:35 (1 week ago)

Latest email

2026-08-19 06:53:46 (1 week ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Committed

PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF

Target version

Authors

Richard Guo (richardguo)

Reviewers

Become reviewer

Committer

Richard Guo (richardguo)

Links

Emails

Reduce LEFT/FULL JOIN to ANTI JOIN in more cases: First at 2026-06-05 02:55:12 by Richard Guo <guofenglinux at gmail.com>
Latest at 2026-08-19 06:53:46 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v1-0001-Collect-quals-for-outer-join-reduction-on-demand.patch) at 2026-08-19 06:53:46 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v1-0001-Collect-quals-for-outer-join-reduction-on-demand.patch) at 2026-08-19 06:53:46 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (v3-0001-Reduce-LEFT-JOIN-to-ANTI-JOIN-using-quals-within-.patch) at 2026-08-18 08:10:34 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (v2-0001-Reduce-LEFT-JOIN-to-ANTI-JOIN-using-quals-within-.patch) at 2026-06-15 09:08:36 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Reduce-LEFT-JOIN-to-ANTI-JOIN-using-quals-within-.patch) at 2026-06-05 02:55:12 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)

History

When	Who	What
2026-08-21 07:24:35	Richard Guo (richardguo)	Closed in commitfest PG20-2 with status: Committed
2026-08-21 07:24:35	Richard Guo (richardguo)	Changed committer to richardguo
2026-08-18 08:31:37	CFbot	Patch does not need rebase anymore
2026-08-17 07:28:58	Richard Guo (richardguo)	Moved from CF PG20-1 to CF PG20-2
2026-07-10 03:16:30	CFbot	Patch needs rebase
2026-06-15 09:25:47	Richard Guo (richardguo)	Attached mail thread CAMbWs49H9khf+1GwyzD0TYaks6cE-OU+1mbUiOn3gZSoBiO7zg@mail.gmail.com
2026-06-15 09:25:47	Richard Guo (richardguo)	Created patch record