Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.