Increase the Maximum Number of Files Open

Vertica requires a large number of file handles. To avoid "too many files open" errors:

1. Check the current limit:

   $ ulimit -n

2. If necessary, permanently increase this limit for all users by editing the file /etc/security/limits.conf and adding the lines:

   * soft nofile 65536

   * hard nofile 65536

   The leading asterisk means that the setting applies to all users.

3. Reload the config file:

   # sysctl -p

4. Log out and log in again. The new shell will have the new ulimit setting.

Note

If the nofile parameter is less than 32768, Vertica fails and logs the following message:

Not enough open file handles allowed (1024 available/32768 required); see 'ulimit -n'.