PROJECTION_STORAGE
While developing your application, monitor the ROS count over time. To monitor the ROS count:
- Query the ROS_COUNT field in the PROJECTION_STORAGE system table.
- Query partitions that show the ROS_COUNT per partition.
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)