RE: Plan a filtering inner join as a semijoin

From: William Bernbaum <wbernbaum(at)dwdev(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: RE: Plan a filtering inner join as a semijoin
Date: 2026-08-27 13:04:37
Message-ID: PH0PR18MB4443C25EEB29A60F31E03A3BA6AD2@PH0PR18MB4443.namprd18.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Withdrawn, superseded by:

https://www.postgresql.org/message-id/PH0PR18MB444315CD3E17255AB4A629BEA6AD2%40PH0PR18MB4443.namprd18.prod.outlook.com

This patch converted a join at rewrite time. The new one builds a
second relation, carries it through the join search, and leaves the choice to
cost. It gets better plans than this one did too, in more cases.

Thanks for the review, Tom.
Will

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matt Blewitt 2026-08-27 13:20:11 Re: [PATCH] Fix JSON_SERIALIZE() coercion placeholder type for jsonb input
Previous Message Maksim.Melnikov 2026-08-27 12:46:35 Re: Fix race with LLVM and bison.