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