Improving Indexes and Constraints Creation Speed

Improving indexes and constraints creation speed

Using the LOAD export type and a file containing SQL orders to perform, it is possible to dispatch those orders over multiple PostgreSQL connections. To be able to use this feature, the PG_DSN, PG_USER and PG_PWD must be set. Then:

ora2pg -t LOAD -c config/ora2pg.conf -i schema/tables/INDEXES_table.sql -j 4

will dispatch index creation over 4 simultaneous PostgreSQL connections.

This will considerably accelerate this part of the migration process with huge data sizes.