Reduce outer joins in more cases

Title

CI (CFBot)

Needs rebase! Needs rebase since 1 month. Failing since 1 month.
Additional links previous successfully applied patch (outdated):

Stats (from CFBot)

Unknown

Tags

Performance

Created

2026-06-15 09:25:47

Last modified

2026-08-17 07:28:58 (1 hour ago)

Latest email

2026-06-23 06:16:52 (1 month ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Needs review

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

Target version

Authors

Richard Guo (richardguo)

Reviewers

Become reviewer

Committer

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-06-23 06:16:52 by wenhui qiu <qiuwenhuifx at gmail.com>
Latest 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>
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-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