On Tue, Jul 10, 2018 at 1:13 PM, Ravi Krishna <srkrishna(at)yahoo(dot)com> 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
>
https://fle.github.io/temporarily-disable-all-indexes-of-a-postgresql-table.html