Improve loading on partition tables

[cataphract]

Data should be loaded on tables without indexes or with the indexes disabled, in order to improve speed. The index should then be created at the end.

On PostgreSQL, this is fairly trivial, the parititioning tasklet has to be called twice, once before the main data load step to create the partition and another time afterwards to create the indexes (including primary keys and unique constraints).

On Oracle, the best way is to create a new unpartitioned table and then EXCHANGE this unpartitioned table for a new partition in the final table. The Oracle documentation has the details.