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
Table compression Ratio
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Table compression Ratio
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.