Skip to main content
Question

Memory configuration

  • February 5, 2020
  • 1 reply
  • 8 views
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?

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • February 5, 2020

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement