search

laurenz / oracle_fdw

PostgreSQL Foreign Data Wrapper for Oracle
http://laurenz.github.io/oracle_fdw/
Other
496 stars 156 forks source link

Slowly operation of data overload. #686

Closed Barsu4ello closed 4 months ago

Barsu4ello commented 4 months ago

Hello again, dear developers!

I have operation of data overload like this: INSERT INTO target_table (column1, column2, column3) SELECT column1, column2, column3 FROM source_table WHERE condition;

And if i need overload 200 000 row this spent 4-5 min. Each row contains 7 field (character varying(256)). This situation is normally or mayby i can do it faster? Thank you very much!

laurenz commented 4 months ago

If target_table is an oracle_fdw foreign table, that is pretty normal. Each inserted row is a round trip between PostgreSQL and Oracle, so with a network latency of 0.5 milliseconds, that's the duration I would expect.

Barsu4ello commented 4 months ago

Thnak you very much for this information! Good day!