How to speed up Oracle to PostgreSQL data transfer
It might be worth pushing a subset to a file and loading it with copy, just to get a sense of the throughput. Copy is...legendary....for high-speed bulk loading into an empty table.

https://www.postgresql.org/docs/current/sql-copy.html