The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Memory configuration
ljo
Community Edition User
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?
0
Answers
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