Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table

From: Andrei Lepikhov <lepihov(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>
Cc: Илья Жарков <izharkov1243(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, eng eng <pspetrov91(at)gmail(dot)com>
Subject: Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table
Date: 2026-09-01 09:16:54
Message-ID: df139cc4-a9f2-4b85-9528-85c9833cbeef@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 28/07/2026 10:13, Andrei Lepikhov wrote:

Just a rebase onto current master

--
regards, Andrei Lepikhov,
pgEdge

Attachment Content-Type Size
v2-0001-Gate-the-NestLoop-inner-side-with-outer-only-join.patch text/plain 50.9 KB
v2-0002-pg_plan_advice-look-through-gating-Results-on-the.patch text/plain 1.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrei Lepikhov 2026-09-01 09:19:44 Re: Skip .DS_Store files in check_mode_recursive
Previous Message Mihail Nikalayeu 2026-09-01 09:15:09 Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master