Skip to main content

Resource management properties

query.max-cpu-time​

This is the max amount of CPU time that a query can use across the entire cluster. Queries that exceed this limit are killed.

query.max-memory-per-node​

This is the max amount of user memory a query can use on a worker. User memory is allocated during execution for things that are directly attributable to, or controllable by, a user query. For example, memory used by the hash tables built during execution, memory used during sorting, etc. When the user memory allocation of a query on any worker hits this limit, it is killed.

warning

The sum of Resource management properties and Resource management properties must be less than the maximum heap size in the JVM on the node. See Deploying Trino.

note

Does not apply for queries with task level retries enabled (retry-policy=TASK)

query.max-memory​

This is the max amount of user memory a query can use across the entire cluster. User memory is allocated during execution for things that are directly attributable to, or controllable by, a user query. For example, memory used by the hash tables built during execution, memory used during sorting, etc. When the user memory allocation of a query across all workers hits this limit it is killed.

warning

Resource management properties must be greater than Resource management properties.

note

Does not apply for queries with task level retries enabled (retry-policy=TASK)

query.max-total-memory​

This is the max amount of memory a query can use across the entire cluster, including revocable memory. When the memory allocated by a query across all workers hits this limit it is killed. The value of query.max-total-memory must be greater than query.max-memory.

warning

Resource management properties must be greater than Resource management properties.

note

Does not apply for queries with task level retries enabled (retry-policy=TASK)

memory.heap-headroom-per-node​

This is the amount of memory set aside as headroom/buffer in the JVM heap for allocations that are not tracked by Trino.

warning

The sum of Resource management properties and Resource management properties must be less than the maximum heap size in the JVM on the node. See Deploying Trino.

exchange.deduplication-buffer-size​

Size of the buffer used for spooled data during Fault-tolerant execution.