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

Comments

  • 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. https://my.vertica.com/docs/6.1.x/HTML/index.htm#13753.htm

Leave a Comment

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