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) Summary
Stats (from CFBot) Patch version: v1, Patch count: 2, First patch: +459−252, All patches: +469−252
Tags Performance
Created 2026-07-03 12:56:30
Last modified 2026-07-03 12:59:12 (1 hour ago)
Latest email 2026-07-03 10:53:11 (3 hours ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
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-07-03 10:53:11 by Andrei Lepikhov <lepihov at gmail.com>
Latest 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>
    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-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