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

How to save space in Vertica Tables?

Hi all,

I am new in Vertica DB and i haven't all the concepts in mind.

We have some tables with important fields and non-important field, the importants fields must be conserved 20 years the non-important fields must be conserved only 5 years.

We don't want modify our table structure and we want to stock all the data in the same tables.

My question is, if we make and UPDATE of the historic (+5 years old data) non-important fields to VOID, NULL, '' or O we could save some space in disk. In theory to have few volatility in the possible value of the fields allow a better compression.

This is right?

In ours tables the 40% of the fiels are important and the 60% non important.

Thanks in advance,
Sergi

Tagged:

Answers

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.