Search Postgresql Archives

Re: Disabling/Enabling index before bulk loading

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux