The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Max Open Files Limit

andriiandrii Vertica Customer

according the documentation:
"The open file limit should be at least 1 file open per MB of RAM, 65536, or the amount of RAM in MB; whichever is greater. "
What is the difference between "1 file open per MB of RAM" and " the amount of RAM in MB"?
Also, do we need to restart Vertica after we increase Max Open Files Limit?


  • Bryan_HBryan_H Vertica Employee Administrator

    That is a mistake in the 9.3.x documentation. In more recent documentation, it is:
    user max open files = greater of { ≥ 65536 | ≤ RAM-MBs }
    This is the correct formula for 9.3.x also.
    You may need to restart Vertica after changing the ulimit in the config file, since it applies at startup, However, Vertica may not start at all, or may experience issues leading to shutdown, if the file limit is too low.

  • andriiandrii Vertica Customer

    Thank you for the explanation!

Leave a Comment

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