Ros container analysis , max size

Moderator: NorbertKrupa

Post Reply
vert_coder
Newbie
Newbie
Posts: 2
Joined: Thu Jun 02, 2016 7:19 am

Ros container analysis , max size

Post by vert_coder » Fri Jun 10, 2016 8:05 am

Hi All,


i have few questions on ros containers :

SELECT * FROM STRATA WHERE projection_name='emp_super';
-[ RECORD 1 ]--------+-------------------------------------
node_name | v_node0001
schema_name | dmem
projection_id | 45035996290954036
projection_name | emp_super
partition_key |
strata_count | 22
merging_strata_count | 3
stratum_capacity | 32
stratum_height | 28.8
stratum_no | 1
stratum_lower_size | 17MB
stratum_upper_size | 489.6MB
ROS_container_count | 4

questions :
--> what is the meaning of ROS_container_count ? means 4 ros containers are associated with this projection .
--> stratum_upper_size --> is this the max size of ros container ?

can we get exact ros container size and numbers via below query ( please confirm my understanding )
select count(ros_count),sum(used_bytes)/1024^3 total_ros_size_gb,anchor_table_name from v_monitor.projection_storage group by 3 ;
ros_count |total_ros_size_gb |Table_name
1 | 21.8931124499068 | emp

is this means table emp has 1 ros container with 21 gb size ?


-->If we are loading multiple tables in a single sessions and commit , is it possible that one ros container share more than 1 table (means different tables projections ) ?



Thanks :

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

Re: Ros container analysis , max size

Post by JimKnicely » Thu Sep 22, 2016 8:53 pm

HI,

Checkout the following links. They do a great job of explaining ROS Containers...
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”