Hi!
[DELETED]
Containers count mismatch
Moderator: NorbertKrupa
Re: Containers count mismatch
Last edited by id10t on Wed May 06, 2015 5:53 pm, edited 1 time in total.
Re: Containers count mismatch
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.
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.
- Attachments
-
- Vertica Storage Pattern.pptx
- Vertica Storage Pattern
- (85.84 KiB) Downloaded 786 times
Re: Containers count mismatch
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:51 pm, edited 1 time in total.
Re: Containers count mismatch
Further....
I took one table and tried to find the partitions it has
I get 108 partitions
The above value was 387
So I assume it has 108 partition having 387 ROS Containers
Now I check the storage_containers tables
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.
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
Code: Select all
select count(ros_id) from partitions where table_schema = 'xxxx' and projection_name like 'xxxx'
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
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.