The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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?