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 :
Ros container analysis , max size
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Ros container analysis , max size
HI,
Checkout the following links. They do a great job of explaining ROS Containers...
Checkout the following links. They do a great job of explaining ROS Containers...
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.