> > 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.
