On Wed, Apr 9, 2025 at 6:18 PM David Rowley <dgrowle...@gmail.com> wrote: > On Wed, 9 Apr 2025 at 18:48, Richard Guo <guofengli...@gmail.com> wrote: > > Perhaps we could spend some planner cycles proving inner_unique for > > anti joins, so that Memoize nodes can be considered for them?
> Worth a try. It should be pretty easy to enable, as far as I can see. > It might just be a case of shuffling the cases around in the switch > statement in add_paths_to_joinrel(). Right. Here is a patch for that. Thanks Richard
v1-0001-Enable-use-of-Memoize-for-ANTI-joins.patch
Description: Binary data
