v.25.4Improvement

Support configurable per task waiting time

Support configurable per task waiting time of low priority query in session level and in server level. #77013 (VicoWu).
Support configurable per task waiting time for low priority queries at both session and server levels.

Why it matters

This feature addresses the need to manage resource allocation more granularly by allowing users to configure how long low priority queries wait per task before execution. It helps in optimizing query scheduling and improving overall system responsiveness under load.

How to use it

Users can set the waiting time for low priority queries either in the server configuration or on a per-session basis. This is done by configuring the corresponding settings that define the maximum wait time per task for low priority queries.