Estimating the Compression Ratio for a Vertica Schema


Depending on the size of your database it may take a long time for the audit function to complete. HP Vertica cautions against doing a detailed, low error-tolerant audit audit on a production database since it will cause all of the data in the database to be dumped in a raw format to calculate its size. To speed up the AUDIT function, we can look at just a specific schema, or modify the parameters inside the function to be less detailed and more error tolerant.

About the author / 

Doug Harmon

Doug is a Technical Consultant and author's his own blog at He has written the Vertical SQL Toolbelt that contains shell scripts and other helpful diagnostic queries.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: