The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

maximum number of ROS containers

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

Comments

  • chaimachaima Employee

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

  • Jim_KnicelyJim_Knicely Administrator

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

  • 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.

  • 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.