We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Data Loading and configuration parameters — Vertica Forum

Data Loading and configuration parameters

I'd like to load large files (from 1GB up to 100GB) and I'm wondering if there are any configuration parameters that can accelerate the data loading. Do you have any recommendations?

For example, I found that MaxAutoSegColumns parameter is set to 32 by default and don't really know if I can change it because 0 indicates to use all columns in the hash segmentation expression.

Comments

Leave a Comment

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