Table compression Ratio

Moderator: NorbertKrupa

Post Reply
yeswanth
Newbie
Newbie
Posts: 4
Joined: Fri Feb 05, 2016 4:21 am

Table compression Ratio

Post by yeswanth » Tue Mar 08, 2016 2:38 pm

Hi Team,

The compression ratio for a particular table varies frequently when the data is loaded.
1. Why it varies when data loaded
2. What steps to be taken to make it constant ( compression >= 3 or = 4)
3. How to make the compression ratio to 4

Please suggest.

Thanks & Regards,
Yeswanth

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Table compression Ratio

Post by JimKnicely » Tue Mar 08, 2016 10:42 pm

How are you loading the data? Are you using the default settings and loading into the WOS which is uncompressed and then measuring compression? When the data moves from WOS to ROS and gets compressed.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “General”