Re: Disabling/Enabling index before bulk loading

From: Ravi Krishna <srkrishna(at)yahoo(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: PG mailing List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Disabling/Enabling index before bulk loading
Date: 2018-07-10 17:13:53
Message-ID: E6BC317E-76F8-43C7-B735-429797952B28@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Xiao Ba 2018-07-10 17:53:07 Refresh materialized view deadlocking?
Previous Message Adrian Klaver 2018-07-10 16:43:40 Re: Disabling/Enabling index before bulk loading