Re: Oracle_FDW table performance issue

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: aditya desai <admad123(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Oracle_FDW table performance issue
Date: 2022-07-11 12:13:08
Message-ID: 20220711121308.GS13040@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 ?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message aditya desai 2022-07-11 12:22:40 Re: Oracle_FDW table performance issue
Previous Message aditya desai 2022-07-11 12:08:34 Oracle_FDW table performance issue