Difference in license data size between Vertica 6 and Vertica 7

okl_sde · June 2015

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.

[Deleted User] · July 2015

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

Sharon_Cutter · July 2015

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

[Deleted User] · July 2015

Sorry, yes the latter is correct. Thanks!

We're Moving!

Create My New Community Account Now

Difference in license data size between Vertica 6 and Vertica 7

Comments

Leave a Comment