Can I tune a COPY statement that uses the AUTO option?

Moderator: NorbertKrupa

Post Reply
Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

Can I tune a COPY statement that uses the AUTO option?

Post by Brett » Mon Dec 01, 2014 3:35 am

Hi all,

Is there a way that I can get faster load times when using the COPY command that invokes the AUTO option? I am using Informatica to load data into Vertica. When Informatica generates COPY command in Vertica they use the AUTO option and I have no way of specifying the DIRECT option in the version that I am using.

I've read that I could increase the memory in the wosdata resource pool prior to a data large data load? Is this the best solution?

Thank you.

Post Reply

Return to “Vertica Data Load”