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
andrii
Vertica Customer
Hi,
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?
0
Comments
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.
Thank you for the explanation!