Skip to main content

Short Query Bias (SQB) function at Netezza/PureData

  • September 12, 2018
  • 2 replies
  • 8 views

Kaito
Forum|alt.badge.img+2
  • Participating Frequently

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

2 replies

Ben_Vandiver
Forum|alt.badge.img
  • Participating Frequently
  • September 12, 2018

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
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 14, 2018

Thanks, Ben!