Search found 9 matches
- 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...
- 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 ...