The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Is adding new column to vertica table expensive?

If I have large table with ex. 500milion rows, is adding new column with no value exspensive? Is there some description in documentation about this. Thanks, Josip


  • No. No value should be immediately
    tested on 20TB, Vertica 7
  • Thanks Daniel. Is there any summary of that test or something about that?
  • Hi!

    Just say what I did and what I can confirm :)
  • Thanks one more time :)

  • Thanks Daniel for the real-world data.

    We intend that this sort of operation should be fast.  So, it's good to have someone else confirm that it actually is :-)

    For what it's worth, as a column-store database, it is our design intention that column-level operations such as adding columns should always be cheap, whether you have 500 million rows, 500 billion rows, or even more than that.


Leave a Comment

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