local segments

Navin_C

Hello All,

Any way we can determine how many segments for each partition.
I know we can check the scaling factor, but that is number of segments allowed per partition.
I want to check the number of segments actually held by each partition in each table

Thanks

zvika_gutkin

Here is a great thread that can help you 

https://community.vertica.com/vertica/topics/where_is_projections_segmentation_in_v_catalog