Re: Add semi-join pushdown to postgres_fdw

Tender Wang <tndrwang@gmail.com>

From: Tender Wang <tndrwang@gmail.com>

To: Alexander Korotkov <aekorotkov@gmail.com>

Cc: Alexander Pyhalov <a.pyhalov@postgrespro.ru>, Robins Tharakan <tharakan@gmail.com>, "Fujii.Yuki@df.MitsubishiElectric.co.jp" <Fujii.Yuki@df.mitsubishielectric.co.jp>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>, Ian Lawrence Barwick <barwick@gmail.com>

Date: 2025-03-25T07:04:37Z

Lists: pgsql-hackers

Hi Alexander Korotkov,

I saw the Bug: #18852 fix had been pushed. While I debug the sem- join
pushed down codes,
I wrote a patch to remove an unnecessary check on semijoin_target_ok() in
[1]. The patch
has been reviewed by Alexander Pyhalov. I think it's ready to commit.

Any thoughts?

[1]
https://www.postgresql.org/message-id/flat/CAHewXN=8aW4hd_W71F7Ua4+_w0=bppuvvTEBFBF6G0NuSXLwUw@mail.gmail.com

-- 
Thanks,
Tender Wang

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

postgres_fdw: Avoid pulling up restrict infos from subqueries
- 729fe699e612 17.5 landed
- 023fb512755f 18.0 landed
Add support for deparsing semi-joins to contrib/postgres_fdw
- 824dbea3e41e 17.0 landed
Move PartitioPruneInfo out of plan nodes into PlannedStmt
- ec386948948c 16.0 cited