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.
March 19th 20 at 08:49
0 answer

Find more questions by tags ClickHouse