Short Query Bias (SQB) function at Netezza/PureData

Kaito

Netezza/PureData has Short Query Bias (SQB) function to deal with a short query as priority. How can Vertica achieve a similar function?

https://www.ibm.com/support/knowledgecenter/en/SSULQD_7.1.0/com.ibm.nz.adm.doc/c_sysadm_short_query_bias.html

Ben_Vandiver

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

Kaito

Thanks, Ben!