Options
Short Query Bias (SQB) function at Netezza/PureData
Kaito
Employee
Netezza/PureData has Short Query Bias (SQB) function to deal with a short query as priority. How can Vertica achieve a similar function?
0
Kaito
Employee
Netezza/PureData has Short Query Bias (SQB) function to deal with a short query as priority. How can Vertica achieve a similar function?
Comments
Each Vertica resource pool has a setting 'RUNTIMEPRIORITYTHRESHOLD' which indicates how long to run each with HIGH priority before reverting to the runtime priority specified by the pool. The threshold defaults to 2 seconds. This accomplishes SQB - queries when they start get more CPU to see if they can be completed quickly, if not, they behave as normal.
https://my.vertica.com/docs/9.1.x/HTML/#Authoring/SQLReferenceManual/Statements/ALTERRESOURCEPOOL.htm#RUNTIMEPRIORITYTHRESHOLD
Thanks, Ben!