For using DIRECT load method with GZIP format, what size to consider

sverma28

Hi I want to load data in VERTICA with COPY command for GZIP file format. The guide says we can use DIRECT method when the size is > 100MB. My question is when I am loading data in GZIP format, what size should I consider to use DIRECT or not? Is it the raw data size or compressed data size(size of gzip file)? A quick help on this will be appreciated

Jim_Knicely

You need to consider the RAW size as Vertica decompresses the GZIP data before loading it.

sverma28

Thanks for the quick response