Re: Foreign table performance issue / PostgreSQK vs. ORACLE - Mailing list pgsql-general

From Tom Lane
Subject Re: Foreign table performance issue / PostgreSQK vs. ORACLE
Date
Msg-id 2781126.1611933365@sss.pgh.pa.us
Whole thread Raw
In response to Re: Foreign table performance issue / PostgreSQK vs. ORACLE  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Foreign table performance issue / PostgreSQK vs. ORACLE
Next
From: "Zwettler Markus (OIZ)"
Date:
Subject: AW: running vacuumlo periodically