| From: | aditya desai <admad123(at)gmail(dot)com> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>, shashissomashekar(at)gmail(dot)com |
| Subject: | Re: Oracle_FDW table performance issue |
| Date: | 2022-07-11 12:22:40 |
| Message-ID: | CAN0SRDFyB5=kRayXtPiA=9LQqPu6nvXJ0OeLzoQQUSuky74cag@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi Justin,
Sorry unable to send a query plan from a closed network. Here the stats are
updated on the Oracle table.
It seems like when joining the local tables it is not filtering data on
Oracle and bringing data to postgres. It is filtering when we actually pass
the values.
Regards,
Aditya.
On Mon, Jul 11, 2022 at 5:43 PM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> 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 ?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2022-07-11 15:26:30 | Re: Oracle_FDW table performance issue |
| Previous Message | Justin Pryzby | 2022-07-11 12:13:08 | Re: Oracle_FDW table performance issue |