Postgres Pro
Downloads
Home   >   mailing lists

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

From Melvin Davidson
Subject Re: Disabling/Enabling index before bulk loading
Date
Msg-id CANu8Fiw1owWzLV8Pt9s4ofJtdjz1=EzbUhL+fLNd6GiwARxbrA@mail.gmail.com
Whole thread Raw
In response to Re: Disabling/Enabling index before bulk loading  (Tim Cross <theophilusx@gmail.com>)
Responses Re: Disabling/Enabling index before bulk loading  (Ravi Krishna <srkrishna@yahoo.com>)
List pgsql-general
Tree view


> We recently did a test on COPY and found that on large tables (47 million rows , 20GB of raw data) the
> difference in COPY with 16 indexes...

I am very suspicious of why you need 16 indexes. Are you sure all those indexes are actually being utilized?
Try executing the attached query, You may find find some are really not needed.

--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
Attachment

pgsql-general by date:

Previous
From: Tim Cross
Date:
Subject: Re: Disabling/Enabling index before bulk loading
Next
From: Hustler DBA
Date:
Subject: Re: Open Source tool to deploy/promote PostgreSQL DDL