Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Main differents between encoding and compression

Hi , What is the main different between encoding and compression ? i know Vertica is able to work on top of encoding data but not on top of compress data its need first to be decompress Did encoding is a stage before compression or its type of compression ?


  • Hi Eli: Conceptually, encoding depends on the data type of the data being encoded, and compression treats a compressed block as opaque / doesn't really care what's in it. That's why Vertica operates on encoded data but not compressed data. Encoding is a separate step that's always performed before compression.
  • Hi Adam , So the data in a column with RLE encoding is both and encoded and compress or it just encoded ?
  • Hi Eli, In that case, when Vertica writes the column to disk, it is both encoded and compressed.
  • Hi aseering,


    Thanks for reply, we have felt a bit confused about your answer. So can we say, encoded column automatically compressed before it written to the disk? Or it is a feature for only RLE encoding type?


    And if it is automatically compressing then could we disable that by any parameter or manual operation. Because we thought it would be fast to read uncompressed data from disk in proportion to compressed data. (Please assume that we have enough space in db)


    Thanks a lot.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.