Hi All,
We are moving a table (with almost a billion rows) to Postgres from Oracle using oracle_fdw. We have discovered that there is a single row fetch limitation in oracle when pulling a row that contains a clob column into Postgres.
My question is, other than running multiple oracle_fdw parallel threads to speed up the data load are there any other optimizations that we may be unaware for oracle_fdw when working with Oracle clob columns?
Any suggestions would be appreciated,
We are moving a table (with almost a billion rows) to Postgres from Oracle using oracle_fdw. We have discovered that there is a single row fetch limitation in oracle when pulling a row that contains a clob column into Postgres.
My question is, other than running multiple oracle_fdw parallel threads to speed up the data load are there any other optimizations that we may be unaware for oracle_fdw when working with Oracle clob columns?
Any suggestions would be appreciated,
Craig Jackson
