PROJECTION_STORAGE

While developing your application, monitor the ROS count over time. To monitor the ROS count:

The default maximum for the ROS_COUNT field is 1024. The ROS_COUNT value should not come close to 1024 for the duration of a partition and through the time it takes an old partition to merge. If the ROS_COUNT field does not come close to 1024, your loading techniques should be adequate.

VMart=> SELECT projection_id, projection_name, ros_count 
        FROM projection_storage;
   projection_id   |       projection_name       | ros_count 
-------------------+-----------------------------+-----------
 45035996273719430 | promotion_dimension_super   |        1
 45035996273720042 | online_page_dimension_super |        1
 45035996273719788 | employee_dimension_super    |        1
 45035996273719276 | store_dimension_super       |        1
 45035996273719610 | customer_dimension_super    |        1
 45035996273722132 | T_super                     |        1
 45035996273719098 | product_dimension_super     |        1
 45035996273719942 | warehouse_dimension_super   |        1
 45035996273720000 | shipping_dimension_super    |        1
 45035996273720498 | online_sales_fact_super     |        1
 45035996273719536 | vendor_dimension_super      |        1
 45035996273720206 | store_sales_fact_super      |        1
 45035996273720652 | inventory_fact_super        |        1
 45035996273718920 | date_dimension_super        |        1
 45035996273720336 | store_orders_fact_super     |        1
 45035996273720100 | call_center_dimension_super |        1
 45035996273722194 | T2_super                    |        1
(17 rows)