Search found 9 matches

by fane89
Wed Jul 26, 2017 12:43 pm
Forum: Vertica Data Load
Topic: Loading data via COPY to a table without ksafty.
Replies: 4
Views: 52866

Re: Loading data via COPY to a table without ksafty.

Hi, I'm trying to optimize the COPY process. when loading data via COPY (using direct) to a table with ksafty=0 times are faster, then loading to table with ksafty=1 or 2. The perfect solution would be to load to a temporary table, but i need access to data between sessions. For example: Loading 10G...
by fane89
Tue Jul 25, 2017 9:38 am
Forum: Vertica Data Load
Topic: Loading data via COPY to a table without ksafty.
Replies: 4
Views: 52866

Loading data via COPY to a table without ksafty.

Hello, I've search the forum, but could not find any solutions, please point me in the right direction if i missed something. Question: Is there a way to load data via copy to a table with ksafty=0 (when global ksafty is not 0)? Loading to a temporary table is not a solution for me, i need the data ...

Go to advanced search