Comments

• vcarusi ✭✭

  June 2019

  Here is an interesting description
  https://forum.vertica.com/discussion/234883/file-handle-count-calculation

  0
• skeswani - Select Field - Employee

  June 2019

  for dbadmin run the following command. It will show how many file descriptors are available

  ulimit -a

  They can be increased in /etc/security/limits.conf as you have shown above.

  note, the increase requires either a reboot or a relogin by the dbadmin user.

  ulimit -a will tell you how many FDs are available

  1
• vcarusi ✭✭

  June 2019

  Yes, it worked.

  https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/InstallationGuide/BeforeYouInstall/openfilelimits.htm
  The open file limit should be at least 1 file open per MB of RAM, 65536, or the amount of RAM in MB.

  1. In my case, I use a virtual machine and I could increase the amount of RAM, from 60 GB to 122 GB.
  2. I modified /etc/security/limits.conf, changing
     hard nofile 65536 -> 122000
     soft nofile 65536 -> 122000
     dbadmin - nofile 65536 -> 122000
  3. restarted the machine

  My conclusion is: there is a connection between number of ROS containers, number of columns and the amount of RAM. More columns I need to select, more RAM I need.

  0
• vcarusi ✭✭

  June 2019

  Also, I used
  lsof | wc -l <- to see the number of open files
  lsof | grep "vertica" | wc -l <- files open by vertica

  0
• vcarusi ✭✭

  June 2019

  https://forum.vertica.com/discussion/234883/file-handle-count-calculation

  0
• vcarusi ✭✭

  June 2019

  https://forum.vertica.com/discussion/234883/file-handle-count-calculation

  0
• vcarusi ✭✭

  June 2019

  https://forum.vertica.com/discussion/234883/file-handle-count-calculation

  0