Skip to main content

maximum number of ROS containers

  • April 18, 2019
  • 4 replies
  • 7 views

vcarusi
Forum|alt.badge.img+1

Hi,
Is there a maximum limit for the number of ROS containers ?
Could I set it to 99999 ?
Thank you,
Veronica

4 replies

chaima
Forum|alt.badge.img+2
  • Participating Frequently
  • April 19, 2019

Hi,
The limit of ROS containers per projection is 1024.
Why would you need 99999 :) ?
Chaima


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • April 19, 2019

@vcarusi - Do not mess with the max ROS containers per projection. You'll run into issues and your database performance will be adversely affected!


vcarusi
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • April 22, 2019

Hi Jim,
You are right. I meant the number of ROS containers per projection.
I have a 70 GB table, with only one projection, and many processes that insert/update/select into/from it.
The default maximum number of ROS containers was reached many time. I noticed the server was finding the table locked/involved in other processes, when it tried to mergeout the table. Thus, the mergeout wasn't executed and the number of containers increased.
First solution was to double the maximum number of ROS containers. For a period it worked. But, again, the limit was reached.
Then, I scheduled a mergeout when no process were modifying the table. The result is that, now, I have only one container.
I don't know if is good or bad.


vcarusi
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • April 23, 2019

Is there a way to split data from a ROS containers? I have a big container 130 GB. I would like to have 1000 smaller containers.
Thank you,
Veronica