Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Real memory usage doesn't match resource groups; how can we improve estimation of query needs?
Deb_Chatigny
Administrator
We frequently encounter situations where our resource groups have been fully allocated during peak periods but our real memory utilization in Linux and the first tab of management console is only about 50%. How can we improve Vertica's estimation of how much memory each query will need?
Question from Optimizing Query Performance and Resource Pool Tuning @rbankula @bat
Tagged:
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Keep in mind that Vertica allocates memory to a query based on the query budget you set, not always the actual memory used (though in some cases Vertica will allocate less than the budget). Query Budget is typically MaxMemorySize (or MemorySize if that value is set) divided by PlannedConcurrency. Each session coming into that pool is allocated that amount. If you adjust those values and set a lower query budget per session, you will see the allocation in the pool go down.