Is there a way to set queuetimeout at query or session level?

brochabrocha Vertica Customer

I am trying to limit how long a query runs. So I set SESSION RUNTIMECAP. This works when there is no queue. But if my query enters the queue - it seems like the time it spends in the queue is not considered part of the RUNTIMECAP calculation. Is there a way on a session or query level to limit how long a query is allowed to be in the queue? Or is the only way to do this by defining a separate resource pool with a low (or 0) setting for QUEUETIMEOUT?

Best Answer

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file