table raw size vs compressed size

Moderator: NorbertKrupa

Post Reply
potluri27
Newbie
Newbie
Posts: 8
Joined: Thu Sep 13, 2012 5:43 am

table raw size vs compressed size

Post by potluri27 » Fri Sep 14, 2012 3:22 pm

how to calculate table RAW size and compression achieved ?

is ros_used_bytes column in projection_storage tells us about RAW size or compressed size ?

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: table raw size vs compressed size

Post by jpcavanaugh » Fri Sep 14, 2012 7:54 pm

To get the raw size, check out the audit function please - http://my.vertica.com/docs/6.0.0-1/HTML ... #15450.htm

Post Reply

Return to “Vertica Administration Tools”