| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Thomas Kellerer <shammat(at)gmx(dot)net> |
| Cc: | "Markhof, Ingolf" <ingolf(dot)markhof(at)de(dot)verizon(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Foreign table performance issue / PostgreSQK vs. ORACLE |
| Date: | 2021-01-29 15:16:05 |
| Message-ID: | 2781126.1611933365@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thomas Kellerer <shammat(at)gmx(dot)net> writes:
> Markhof, Ingolf schrieb am 29.01.2021 um 13:56:
>> So, I wonder: Is there a fundamental difference between Oracle
>> database links and foreign tables in PostgreSQL that could explain
>> the different run times?
> My guess is, that your queries use predicates that can't be pushed down
> to the foreign server on Postgres, but Oracle can.
> If my assumption is correct, then maybe if you showed one example query,
> it might be possible to figure out a way to restructure it.
More generally:
https://wiki.postgresql.org/wiki/Slow_Query_Questions
These sorts of questions seldom have generic fixes, but if you give
us enough detail, we might be able to help.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zwettler Markus (OIZ) | 2021-01-29 15:44:11 | AW: running vacuumlo periodically |
| Previous Message | Thomas Kellerer | 2021-01-29 14:40:21 | Re: Foreign table performance issue / PostgreSQK vs. ORACLE |