We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

Short Query Bias (SQB) function at Netezza/PureData — Vertica Forum

Short Query Bias (SQB) function at Netezza/PureData

Kaito

Kaito Employee

September 2018 in General Discussion

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

0

Comments

Ben_Vandiver Employee

September 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

1
Kaito Employee

September 2018

Thanks, Ben!

0

Leave a Comment