Re: Fwd: increase insert into local table from remote oracle table preformance

Did you try - runing multiple inserts in parallel, - Stop wal archiving, - Tune fetch sise ? Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Fwd: increase insert into local table from remote oracle table preformance

Hi, I'm using postgresql v10.4. I have a local partitioned table (by range - data, every day has its own table). I'm using the oracle_fdw extension to bring data from the oracle partitioned table into my local postgresql (insert into local select * from remote_oracle). Currently, I dont have any in