BUG #15506: Foreign data wrapper (postgres_fdw) unexpected behavior

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: timur(dot)luchkin(at)gmail(dot)com
Subject: BUG #15506: Foreign data wrapper (postgres_fdw) unexpected behavior
Date: 2018-11-14 09:44:42
Message-ID: 15506-9c8798a2d6cd06b0@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15506
Logged by: Timur Luchkin
Email address: timur(dot)luchkin(at)gmail(dot)com
PostgreSQL version: 10.5
Operating system: Ubuntu 16.04.4 LTS
Description:

I'm trying to use "use_remote_estimate = false" mode of the postgres_fdw.
I have a very huge remote tables (several TBytes) already analyzed locally.

When I trying to analyze the foreign table itself , - it takes all the
incoming network traffic (400Mbit) and can't complete in 10 minutes (I can't
wait more, because it affects production environment).
Why the analyze of the foreign table can't just take already collected
statistics from the remote server? Is it a bug or some limitation?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Paul van der Linden 2018-11-14 10:15:38 Difference in queryplan for array-contains vs unnest
Previous Message PG Bug reporting form 2018-11-14 08:44:13 BUG #15505: pgadmin 4