>
> Did you include the time to CREATE INDEX after the COPY or is the 1:14 only for the COPY stage?
Yes.
Time taken to load 47 mil rows with all 16 indexes intact: 14+ hrs
Time taken to load the same after dropping index and then loading and finally creating 16 indexes: 1 hr 40 min
Frankly I am surprised by this staggering difference.