Page 2 of 2
Re: Containers count mismatch
Posted: Wed Mar 26, 2014 5:05 pm
by id10t
Hi!
[DELETED]
Re: Containers count mismatch
Posted: Thu Mar 27, 2014 9:52 am
by nnani
Hello Sharon and Skwa,
Thanks for a detailed information on this topic.
Further I jotted down my understanding on this ppt.
The ppt only has a flow and storage pattern in Vertica.
Coming to calculation:
If I want to know number of total ROS container for a particular projection
number of partitions * local_segments * nodes
Is there any way we can see how many local segments are actually present for a particular partition ?
Please go through it and let me know, if my understanding matches your explanation.
Thanks for your time.
Re: Containers count mismatch
Posted: Thu Mar 27, 2014 10:45 am
by id10t
Hi!
[DELETED]
Re: Containers count mismatch
Posted: Thu Mar 27, 2014 10:53 am
by nnani
Further....
I took one table and tried to find the partitions it has
Code: Select all
select count(distinct(date_trunc('week', cast(cast(period_key as varchar)as date)))) from xxxxx
I get 108 partitions
Code: Select all
select count(ros_id) from partitions where table_schema = 'xxxx' and projection_name like 'xxxx'
The above value was 387
So I assume it has 108 partition having 387 ROS Containers
Now I check the storage_containers tables
Code: Select all
select node_name,count(storage_oid) from v_monitor.storage_containers where storage_type='ROS' and
schema_name='xxxx' and projection_name like 'xxxx' group by node_name order by node_name
This also shows me proper distribution of ROS containers on all nodes and the total comes to be 387
Till this point my calculations are correct according to understanding.
The I try to do this calculation number of partition * local_segments *number of nodes
In my case
108*4*10 = 4320
This is a Odd Number which I was not expecting.