Lazy LEFT NestLoop JOIN: gate rescanning of the inner side by outer-side-only join clauses

Edit
ID 6981
Title Lazy LEFT NestLoop JOIN: gate rescanning of the inner side by outer-side-only join clauses
CI (CFBot) Needs rebase! Needs rebase since 23 hours. Failing since 3 months.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Performance
Created 2026-07-03 12:56:30
Last modified 2026-10-02 06:26:30 (2 weeks ago)
Latest email 2026-09-15 09:59:56 (1 month ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
Target version 20
Authors Andrei Lepikhov (lepikhov), Mikhail Zhilin (mizhka-at-pgpro), Peter Petrov (pspetrov)
Reviewers Become reviewer
Committer
Links
Emails
Do not scan index in right table if condition for left join evaluates to false using columns in left table
First at 2024-12-07 18:30:46 by Илья Жарков <izharkov1243 at gmail.com>
Latest at 2026-09-15 09:59:56 by Andrei Lepikhov <lepihov at gmail.com>
Latest attachment (v4-0001-Gate-the-NestLoop-inner-side-with-outer-only-join.patch) at 2026-09-15 09:59:56 from Andrei Lepikhov <lepihov at gmail.com>
    Attachment (v4-0001-Gate-the-NestLoop-inner-side-with-outer-only-join.patch) at 2026-09-15 09:59:56 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
    Attachment (v3-0001-Gate-the-NestLoop-inner-side-with-outer-only-join.patch) at 2026-09-12 12:02:23 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
    Attachment (v2-0001-Gate-the-NestLoop-inner-side-with-outer-only-join.patch) at 2026-09-01 09:16:54 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
    Attachment (0001-Gate-the-NestLoop-inner-side-with-outer-only-join-cl.patch) at 2026-07-28 08:13:19 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
    Attachment (v1-0001-Gate-the-NestLoop-inner-side-with-outer-only-join.patch) at 2026-07-03 10:53:11 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v0-0001-Gate-the-NestLoop-inner-side-with-outer-only-join.patch) at 2026-06-30 08:20:52 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (0001-Gate-the-NestLoop-inner-side-with-outer-only-join-cl.patch) at 2026-05-27 10:11:17 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (reproduction.sql) at 2024-12-16 09:58:52 from eng eng <pspetrov91 at gmail.com> (Patch: No)
    Attachment (reproduction.sql) at 2024-12-08 02:23:42 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
History
When Who What
2026-10-20 01:38:25 CFbot Patch needs rebase
2026-10-02 06:26:30 Andrei Lepikhov (lepikhov) Moved from CF PG20-2 to CF PG20-3
2026-09-01 09:31:42 CFbot Patch does not need rebase anymore
2026-08-31 00:58:29 CFbot Patch needs rebase
2026-07-28 08:34:47 CFbot Patch does not need rebase anymore
2026-07-08 15:11:26 CFbot Patch needs rebase
2026-07-03 12:59:12 Andrei Lepikhov (lepikhov) Changed authors to Andrei Lepikhov (lepikhov), Mikhail Zhilin (mizhka-at-pgpro), Peter Petrov (pspetrov)
2026-07-03 12:59:12 Andrei Lepikhov (lepikhov) Changed name to Lazy LEFT NestLoop JOIN: gate rescanning of the inner side by outer-side-only join clauses
2026-07-03 12:56:31 Andrei Lepikhov (lepikhov) Attached mail thread CAKE=rqQ-LHuh2eVsKC7ihkRJoCBZafSR72o3Xk4Xb=LcQMQfsA@mail.gmail.com
2026-07-03 12:56:30 Andrei Lepikhov (lepikhov) Created patch record
Edit