Postgres Pro
Downloads
Home   >   mailing lists

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

From Vick Khera
Subject Re: Disabling/Enabling index before bulk loading
Date
Msg-id CALd+dcfqWoDtX-D234p0Lh2H9eZb99qeeh3qFyg7vuVpsq8SAg@mail.gmail.com
Whole thread Raw
In response to Re: Disabling/Enabling index before bulk loading  (Ravi Krishna <srkrishna@yahoo.com>)
Responses Re: Disabling/Enabling index before bulk loading
List pgsql-general
Tree view
On Tue, Jul 10, 2018 at 1:13 PM, Ravi Krishna <srkrishna@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


pgsql-general by date:

Previous
From: Patrick Hemmer
Date:
Subject: max_standby_streaming_delay not enforced
Next
From: Ravi Krishna
Date:
Subject: Re: Disabling/Enabling index before bulk loading