Hi Ingolf,
On 2. Feb 2021, at 13:05, Markhof, Ingolf
mailto:ingolf.mark...@de.verizon.com>> wrote:
Hi!
My PostgreSQL version is 11.8.
The query I am running is referring to a number of foreign tables. The first
one (table1) has to IDs, let's say ID_A and ID_B. While ID_A is unique, ID_B is
n
Cc: pgsql-general@lists.postgresql.org
Subject: [E] Re: Foreign table performance issue / PostgreSQK vs. ORACLE
Hi Ingolf,
> On 29. Jan 2021, at 13:56, Markhof, Ingolf
> wrote:
>
> Hi!
>
> I am struggling with the slow performance when running queries referring to
> for
>
>
> Could there be some tuning option in PostgreSQL to make queries via
> foreign tables faster (e.g. I heard about option fetch_size)?
>
fetch_size can make a difference, but it won't change a query that takes
hours into a query that takes seconds. The default is likely too low,
though.
Have
Hi Ingolf,
> On 29. Jan 2021, at 13:56, Markhof, Ingolf
> wrote:
>
> Hi!
>
> I am struggling with the slow performance when running queries referring to
> foreign tables. – Yes, I know… - Please read the whole story!
Done and it rings a bell or two.
> The set-up basically is a production d
Thomas Kellerer 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
Markhof, Ingolf schrieb am 29.01.2021 um 13:56:
> The set-up basically is a production database and a reporting
> database. As names indicate, the production database is used for
> production, the reporting database is for analysis. On the reporting
> database, the only way to access product data i
