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)

>
> Without the actual query and EXPLAIN ANALYZE on it this will be 
> difficult to answer with any detail.
>
> Also would be nice to have the table schema.
>

Here's the query, schema and the EXPLAIN ANALYZE

query: https://gist.github.com/mewwts/704663e19a21bc51864f3298f09a18c0

plan: https://explain.depesz.com/s/RQFQ


Best,

-- 
Mats
CTO @ Dune Analytics
We're hiring: https://careers.duneanalytics.com