What are the best settings clickhouse for large single-user queries?
What settings in addition to max_threads and max_memory_usage should be modified to configure clickhouse for use by a single user on dedicated to the task virtual machine (allocated only at the instance clickhouse, and in the database there is only 1 user doing the requests sequentially)?
Configuration - 128 logical cores, 386ГБ memory, 1 NVMe drive. The goal is to maximize performance for large selects aggregation and operations on arrays.
If max_threads 128 and max_memory_usage 2E+12 requests immediately after starting rasparallelivanija on 40-128 threads, but after a minute or two calculations begin to run only 4 threads in 6-15% of used memory.