Configuring Memory Resources

To limit the amount of overall system memory that you allocate to the Vertica database, set the MAXMEMORYSIZE parameter on the GENERAL resource pool.

To prevent swapping, verify that your application uses only the memory that the database is not using.

For example, suppose the MAXMEMORYSIZE of the GENERAL pool for the database is set to 32 GB on a system with 48 GB of RAM. In this case, your application should use no more than (48–32) = 16 GB of RAM.