Re: Pathify RHS unique-ification for semijoin planning - Mailing list pgsql-hackers

From Andrei Lepikhov
Subject Re: Pathify RHS unique-ification for semijoin planning
Date
Msg-id 04838e1f-eb8e-46c5-bf7a-62e3f27cd632@gmail.com
Whole thread Raw
In response to Re: Pathify RHS unique-ification for semijoin planning  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Pathify RHS unique-ification for semijoin planning
List pgsql-hackers
On 2/9/2025 12:10, Richard Guo wrote:
> So this specific case runs about 3.7 times faster, which is really
> nice.No questions, it is good enough optimisation. I'm worried only about 
implementation: It creates one more RelOptInfo that may look like a 
baserel, but we can't find it by find_base_rel or even find_join_rel. It 
seems a little inconsistent to me.
Don't think it is critical - just complicates life for extension 
developers in some cases.

-- 
regards, Andrei Lepikhov



pgsql-hackers by date:

Previous
From: Mihail Nikalayeu
Date:
Subject: Re: Adding REPACK [concurrently]
Next
From: Amit Kapila
Date:
Subject: Re: POC: enable logical decoding when wal_level = 'replica' without a server restart