Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

What is the implication of setting RUNTIMEPRIORITYTHRESHOLD to 0 and RUNTIMEPRIORITY to high?


  • Hi Ardavan, The implications are that all the queries that you run in that pool will have HIGH priority all the time. Hope this answer your question, Thanks, Eugenia
  • Hi Ardavan, Value that specifies the time limit (in seconds) by which a query must finish before the Resource Manager assigns to it the RUNTIMEPRIORITY of the resource pool. All queries begin running at a HIGH priority. When a query's duration exceeds this threshold, it is assigned the RUNTIMEPRIORITY of the resource pool. Default is 2. here is the link for the documentation.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.