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?


  • Options
    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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file