Support Limiting Temporary Data Storage on Disk

Why it matters

This feature addresses the problem of uncontrolled growth of temporary data on disk during query execution. By limiting the temporary data size per user and per query, it helps prevent excessive disk usage, ensuring more predictable resource consumption and improving system stability.

How to use it

Users can enable and configure temporary data size limits by setting max_temporary_data_on_disk_size_for_user and/or max_temporary_data_on_disk_size_for_query in the server configuration or at the session/query level. These settings control the maximum disk space used for temporary data respectively for each user and each query.