Company or project name

Conviva

Use case

In priority feature,the hardcode 1 second per task is such a big value that in most cases the low-priority query will get blocked absolutely when higher-priority query kick in. Just an improvement to make it tunable...
In our case, set it up to a smaller value like 50 milliseconds is suitable, in this case, the lower-priority query will move forward just in a slower pace, instead of getting totally blocked.

Describe the solution you'd like

• Add a session level configuration low_priority_query_wait_time_ms to set up the time in milliseconds that our task will block waiting for high priority query to finish
• Add a server level configuration low_priority_query_wait_time_ms to set up the server level default value of it.

Describe alternatives you've considered

No response

Additional context

No response