Difference in license data size between Vertica 6 and Vertica 7
We recently upgraded from Vertica 6.1.3 to Vertica 7.1.2 and noticed a massive reduction in the amount of license data size used by our data. For a single table that was formerly 7.5TB, it is now 4TB. I need to be sure that there was no data loss involved - just something like a redesign of how the license data size is calculated.
In my analysis of this issue, I found a table with 5 columns - all integers - all containing the same 3 records before and after the upgrade. The data in each column was a single digit. Before the upgrade, the license size reported for the table was 30 bytes. After the upgrade it is 15 bytes. This leads me to conclude that Vertica 6 calculated integers as 2 bytes in size from a license perspective whereas Vertica 7 calculates them as 1 byte. Does this sound correct to you? Is there anyone who had a similar experience with license data size when upgrading to Vertica 7?
I am extracting the license byte size for each table from the v_catalog.user_audits table.
Thanks,
Chris.
Comments
Hi Chris,
Thanks for the question. We've had other similar questions so we just wrote a blog about it: https://community.dev.hp.com/t5/Vertica-Blog/Why-Do-My-License-Audits-Show-A-Significant-Size-Reduction/ba-p/231090
Hope this helps!
-Vicki
Looks like the correct link is this:
https://community.dev.hp.com/t5/Vertica-Blog/Why-Do-My-License-Audits-Show-A-Significant-Size-Reduction/ba-p/231099
Sorry, yes the latter is correct. Thanks!