Memory configuration

ljo

Hi,
I have vertica cluster with 3 nodes (9.2 comunity edition), each sever have 8CPU and 96Go RAM. I executed a workload test, my CPU consumption was 95% on each server, but vertica did not use all RAM. The first server use 56Go for memory_caches and the 2 others only 13GO. The general resource pool is set to use 95% of memory max size. I try to set memory max size to 120Go, but apparently, I cannot use more than 96Go. did I miss something in configuration?

Jim_Knicely

Take a lot at the blog post "Do You Need to Put Your Query on a Budget?"
https://www.vertica.com/blog/do-you-need-to-put-your-query-on-a-budgetba-p236830/

And the docs:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManageWorkloads/QueryBudgeting.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Profiling/QueryExecutionSummaryProfiles.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/QUERY_CONSUMPTION.htm

Note that QUERY_CONSUMPTION table in 9.3.0 added a helpful column called PEAK_MEMORY_KB which is the peak memory reserved by the resource manager for a query.

https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/QUERY_CONSUMPTION.htm