Options

Question on space utilization - VARCHAR

nvk9nvk9
in General Discussion

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

  • Options
    Sharon_CutterSharon_Cutter ✭✭

    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...