To regulate memory consumption when creating a storage on systems with limited memory, we recommend determining the current memory usage and increasing the max_server_memory_usage
value. This setting determines the maximum amount of memory that the server can use. This value is specified in bytes.
By default, max_server_memory_usage
is set to 0, which allows the server to use all available memory.
The max_server_memory_usage
value is usually further limited by the max_server_memory_usage_to_ram_ratio
value (the maximum amount of memory that a server can use as a ratio to all available memory). For example, the default value of 0.9 means that the server can consume 90% of the available memory.
When determining the current memory usage, keep in mind the following limitations:
We do not recommend allowing all 100% of the available memory to be used up. This can exhaust RAM when processing incoming requests.