Thomas Kellerer <shammat@gmx.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