On Tue, Jul 10, 2018 at 1:13 PM, Ravi Krishna <srkris...@yahoo.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