@FaheemMitha Not sure I follow what you're asking. Its not unusual to break a large load into smaller batches but you should drop constraints, run your batches, add constraints. Not drop/add within each batch.

@MarkStorey-Smith Right, that's what I thought. dropping and adding constraints seems pretty time-consuming, though I have not measured it.

I'm not sure how long the COPY itself takes, but that seems relatively fast.

For some reason I thought of loads was a good idea, and wen to a lot of trouble to implement it. No idea what I was thinking.

@swasheck oh yes, you're so right. Had so many issues with that shitty driver on my previous machine :|.

@Marian steaming. pile. of poo.

@FaheemMitha network vendor (think Cisco without the gear, budget, or vpn client common sense)

@swasheck Ok. :-)