Oracle_FDW table performance issue

From: aditya desai <admad123(at)gmail(dot)com>
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Oracle_FDW table performance issue
Date: 2022-07-11 12:08:34
Message-ID: CAN0SRDHGDsW0A1cyN=4x9sJNLRbRMP27TfvGbHDikcg2ZBNB9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

select * from from oracle_fdw_table where transaction_id in (
1,2,3,.....,75)--- 23ms.

Could you please help me understand this drastic behaviour change?

Regards,
Aditya.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2022-07-11 12:13:08 Re: Oracle_FDW table performance issue
Previous Message arjun shetty 2022-07-11 07:49:51 functionality difference-performance postgreSQLv14-GCC-llvm-clang