Page 1 of 1

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

Posted: Mon Dec 01, 2014 3:35 am
by Brett
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.