PARTITIONS

While developing your application, monitor the PARTITIONS system table. Make sure that the number of ROS containers per partition does not reach the maximum of 1024.

In addition, monitor the ros_size_bytes field to see if there are any small ROS containers that you can merge.

=> SELECT projection_name, ros_id, ros_size_bytes
   FROM partitions;
 projection_name |      ros_id       | ros_size_bytes 
-----------------+-------------------+----------------
 t_p             | 45035996273740461 |             90 
 t_p             | 45035996273740477 |             99 
 t_p             | 45035996273740493 |             99