Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Memory not utilized above 10% by Vertica
We have a 3 node dev vertica cluster, each node with 24 cores, 96G memory, and 4TB storage @10000 rpm. Even at high server loads with concurrent query and data load going on, the memory usage doesnt go about 10% in each of the node. The CPU is utilized at 100% for all the cores in all nodes. The general resource pool is being used for all querying and data load, and the maxmemorysize is "Special: 95%". Swap is not being used. Are there any parameters to tweak for better memory utilization?