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

Question on space utilization - VARCHAR

If I have a column defined as VARCHAR(2000) and I insert a string

'WonderHowMuchSpaceThisTakes!!!' which has only 30 bytes, will Vertica consume the utilized 30 bytes or the all the allocated 2000?

Comments

  • Vertica stores the 30 characters efficiently on disk in the projection, but you will pay a performance penalty at run-time if varchar columns are "over-declared".  The execution engine will use the full 2000 characters during query execution and will use extra storage for temp space operations.

     

      --Sharon

     

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.