Postgres Pro
Downloads
Home   >   mailing lists

Oracle_FDW table performance issue - Mailing list pgsql-performance

From aditya desai
Subject Oracle_FDW table performance issue
Date
Msg-id CAN0SRDHGDsW0A1cyN=4x9sJNLRbRMP27TfvGbHDikcg2ZBNB9A@mail.gmail.com
Whole thread Raw
Responses Re: Oracle_FDW table performance issue  (Justin Pryzby <pryzby@telsasoft.com>)
Re: Oracle_FDW table performance issue  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: arjun shetty
Date:
Subject: functionality difference-performance postgreSQLv14-GCC-llvm-clang
Next
From: Justin Pryzby
Date:
Subject: Re: Oracle_FDW table performance issue