On Mon, Jul 11, 2022 at 05:38:34PM +0530, aditya desai wrote: > Hi, > I have one Oracle fdw table which is giving performance issue when joined > local temp table gives performance issue. > > select * from oracle_fdw_table where transaction_id in ( select > transaction_id from temp_table) ---- 54 seconds. Seeing HASH SEMI JOIN in > EXPLAIN PLAN. temp_table has only 74 records.
You'd have to share the plan https://wiki.postgresql.org/wiki/Slow_Query_Questions Do the tables have updated stats ?
