Skip to main content

Bulk Loading - gzip or bzip format for copy

  • February 15, 2013
  • 1 reply
  • 4 views
Old_Community
Forum|alt.badge.img+2
Is there any preference over any of the formats? Concerns are time taken to decompress the file by vertica and push to DB. I am using copy from local but network I/O is not an issue as compression achieved in my files is almost similar.

    1 reply

    Old_Community
    Forum|alt.badge.img+2
    • Old_Community
    • Author
    • Participating Frequently
    • February 15, 2013
    Gzip is much faster (but with rather a lot less compression) than Bzip2.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement