Re: postgres_fdw insert extremely slow

On 27.11.2020 10:11, pabloa98 wrote: On Thu, Nov 26, 2020 at 8:25 PM Laurenz Albe > wrote: On Thu, 2020-11-26 at 09:07 -0800, Adrian Klaver wrote: > So even if Mats where to break this query: > > INSERT INTO foreign.labels (address, labels)

Re: postgres_fdw insert extremely slow

On 25.11.2020 18:12, Tom Lane wrote: Mats Julian Olsen writes: On 25.11.2020 17:58, Tom Lane wrote: ... Have you tried looking into pg_locks on the remote server while this query is running? Thanks Tom, I'll try to spin up a regular Postgres instance on both rds and ec2 and see if

Re: postgres_fdw insert extremely slow

On 25.11.2020 17:58, Tom Lane wrote: Mats Julian Olsen writes: Postgres version(s)? x: Aurora PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit (RDS) y: PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg19.10+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.2.1-9ubuntu2

Re: postgres_fdw insert extremely slow

On 25.11.2020 17:57, Adrian Klaver wrote: On 11/25/20 8:48 AM, Mats Julian Olsen wrote: Apologies for the sloppiness! Postgres version(s)? x: Aurora PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit (RDS) y: PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg19.10+1) on

Re: postgres_fdw insert extremely slow

Apologies for the sloppiness! Postgres version(s)? x: Aurora PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit (RDS) y: PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg19.10+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.2.1-9ubuntu2) 9.2.1 20191008, 64-bit (GCP) With

postgres_fdw insert extremely slow

Helle pgsql-general, We have just set up postgres_fdw between two postgres databases, x and y, with the plan to periodically insert data from x into y. We've successfully set up the connection with a few options: `use_remote_estimate 'true'` and `fetch_size '5'` (the latter we've played aroun