Re: Disabling/Enabling index before bulk loading

Поиск

Список

Период

Сортировка

От	Melvin Davidson
Тема	Re: Disabling/Enabling index before bulk loading
Дата	11 июля 2018 г. 04:58:44
Msg-id	CANu8Fiw1owWzLV8Pt9s4ofJtdjz1=EzbUhL+fLNd6GiwARxbrA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Disabling/Enabling index before bulk loading (Tim Cross <theophilusx@gmail.com>)
Ответы	Re: Disabling/Enabling index before bulk loading
Список	pgsql-general

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

В списке pgsql-general по дате отправления:

От: Tim Cross
Дата: 11 июля 2018 г., 04:31:56
Сообщение: Re: Disabling/Enabling index before bulk loading

От: Hustler DBA
Дата: 11 июля 2018 г., 05:04:21
Сообщение: Re: Open Source tool to deploy/promote PostgreSQL DDL