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

Ardavan_Moinzad

[Deleted User]

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

Bhawana

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