On Tue, Jul 10, 2018 at 1:13 PM, Ravi Krishna <srkrishna@xxxxxxxxx> wrote:
>
> 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