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.
- Re: [External] Multiple COPY on the same table Ravi Krishna
- Re: [External] Multiple COPY on the same table Christopher Browne
- Re: [External] Multiple COPY on the same table Vijaykumar Jain
- Re: [External] Multiple COPY on the same table Ravi Krishna
