Vertica Blog

Vertica Blog


Calculating ROI

Learn How Much Money Vertica Can Save Your Business

The ROI for software systems is notoriously tough to pin down. The effort to integrate new software with systems already in place often adds time and labor costs to the upfront investment. What’s more, if there is any cultural resistance to change, then the ROI can be impossible to measure for months or years, or...

Are Your Columns too Wide?

This tip expands on the earlier post on encoding and compression at Checking and Improving Column Compression and Encoding When you have millions to billions of rows, data type becomes a bit more important: even an extra 10 bytes per row across a huge data set will impact storage or performance (or both!). When I...

Checking and Improving Column Compression and Encoding

When working with terabytes of data, storage and transfer become major time and cost sinks. Vertica can help minimize storage cost and transfer time with column compression and encoding. How can we identify Vertica tables that might benefit from compression? Information about column size and current compression is stored across column_storage and projection_columns table. The...

Encode Projection Columns with Zstandard Compression: Quick Tip

Vertica 9.2 now supports the Zstandard Compression Encoding Type which offers higher compression than the BZIP and GZIP Encoding Types! Helpful Link: Have fun!