"James Pang (chaolpan)" <chaol...@cisco.com> writes: > How to make it fast ? These are our steps about copy large data from Oracle > to Postgres > 1. Create table in Postgres 2. Extract data from Oracle to CSV 3. Alter > table set xxx unlogged, 4. Run copy command into Postgres db 5. Alter > table set xxx logged 6. Create index …
The easy answer is to skip steps 3 and 5.
regards, tom lane
