How to speed up Oracle to PostgreSQL data transfer

0 votes

1 answer

353 views

postgresql oracle-12c migration gdal schema-migration

                          I have an Oracle schema that I am transferring to PostgreSQL with ogr2ogr.
This particular table has 5 columns with number(22) each. There are some 300M rows. In under 10 minutes I can transfer this table between two oracle servers over the network. ogr2ogr took a day to transfer 10M records and will take a month to transfer the whole table. 

I suspect the problem is on the receiving end. Data is transferred to AWS PgSQL with 4 Gb ram. How to debug the bottleneck and speed up the transfer?

Asked by Stepan (213 rep)

Jul 26, 2019, 02:14 PM
Last activity: Apr 11, 2022, 11:01 AM

How to speed up Oracle to PostgreSQL data transfer

Related Questions