The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

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

edited February 6 in General Discussion

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

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.