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.