Horton

Re: Pathify RHS unique-ification for semijoin planning

Andrei Lepikhov <lepihov@gmail.com>

View thread
From: Andrei Lepikhov <lepihov@gmail.com>
To: Richard Guo <guofenglinux@gmail.com>, Álvaro Herrera <alvherre@kurilemu.de>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>, Andy Fan <zhihuifan1213@163.com>, wenhui qiu <qiuwenhuifx@gmail.com>
Date: 2025-09-02T10:55:59Z
Lists: 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