Hello all We are often using the oracle_fdw to transfer data between Postgres (version 11+) and Oracle (version 18+). It works great.
However I have a task at hand that requires inserting a few billion rows in an Oracle table from a Postgres query. insert into t_ora (a,b,c) select a,b,c from t_pg; This is driven from a plpgsql stored procedure, if that matters. I want to optimize the running time of this. But I am unsure of which, if any, possibilities there actually is. Reducing the number of network roundtrips is usually a good way to increase throughput. But, how do I do that? If I could make the Oracle insert direct load, that would usually also increase throughput. But, is that possible here. There are no constraints defined on the destinaton tables. Regards Niels Jespersen
