Обсуждение: Re: [External] Multiple COPY on the same table

Поиск
Список
Период
Сортировка

Re: [External] Multiple COPY on the same table

От
Ravi Krishna
Дата:
1. The tables has no indexes at the time of load.
2.  The create table and copy are in the same transaction.

So I guess that's pretty much it.  I understand the long time it takes as some of the tables have 400+ million rows.
Also the env is a container and since this is currently a POC system , not much time has been invested in fine tuning it.

thanks all.