The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

How to calculate raw data size in Vertica database for license?

Vertica licensing is based upon raw database size. How can I calculate raw data size when data in the database is in the compressed form?

Comments

  • Up to Vertica 4.1, users need to run a script manually to calculate this. Users may request this script (database_compression.sh) from Support. This script tells users the approximate raw and compressed data size used in the database. This script requires database administrator user name and password. you may run it like ./datasize_compression.sh -U dbuser -w dbpassword In addition, you can run diag dump script with -c flag. /opt/vertica/scripts/collect_diag_dump.sh -U username -w password -c It will create a zip file including a file named 'compression' that provides raw and compressed data size. Starting in version 5.0 Vertica provides an audit API using functions that help calculate these sizes and license compliance. For example: GET_COMPLIANCE_STATUS --------------------------------------------------- Raw Data Size: 0.071GB +/- 0.003GB License Size : 500.000GB Utilization : 0% Audit Time : 2011-03-09 09:54:09.538704+00 Compliance Status : The database is in compliance with respect to raw data size. License End Date: 04/06/2011 Days Remaining: 28.590 (1 row) Details of how Vertica calculates these sizes appear in the version 5.0 doc umentation section "How Vertica Calculates Database Size" in the Administrator's Guide.

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.