Home > mailing lists

Re: Disabling/Enabling index before bulk loading - Mailing list pgsql-general

From	Ravi Krishna
Subject	Re: Disabling/Enabling index before bulk loading
Date	July 10, 2018 23:13:53
Msg-id	E6BC317E-76F8-43C7-B735-429797952B28@yahoo.com Whole thread Raw
In response to	Re: Disabling/Enabling index before bulk loading (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses	Re: Disabling/Enabling index before bulk loading (Vick Khera <vivek@khera.org>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Adrian Klaver
Date: 10 July 2018, 22:43:40
Subject: Re: Disabling/Enabling index before bulk loading

From: Xiao Ba
Date: 10 July 2018, 23:53:07
Subject: Refresh materialized view deadlocking?

Re: Disabling/Enabling index before bulk loading - Mailing list pgsql-general

Previous

Next