Maximum Memory Maps Configuration

This topic details how to modify the limit for the number memory maps a process can have on your system so that it meets Vertica requirements. The installer reports this issue with the identifier: S0130.

The installer automatically configures the correct setting if the default value does not meet system requirements. If there is an issue setting this value, or you have used the --no-system-configuration argument to the installer and the current setting is incorrect, then the installer reports this as an issue.

Vertica uses a lot of memory while processing and can approach the default limit for memory maps per process.

The recommended value is at least the amount of memory on the system in KB / 16, but not less than 65536.

All Systems

To manually set the memory map limit:

  1. Run /sbin/sysctl vm.max_map_count to determine the current limit.
  2. If the limit is not 65536 or the amount of system memory in KB / 16 (whichever is higher), then edit/add the following line to /etc/sysctl.conf. Replace 65536 with the value for your system.
  3. # The following 1 line added by Vertica tools. 2014-03-07 13:20:31

    vm.max_map_count=65536

  4. Run sysctl -p to apply the changes in sysctl.conf immediately.

These steps will need to be replicated for each node in the cluster.