#support, the clickhouse DB consumes more than 29 GB space for 7 days. is it any possible to reduce the memory consumption?

How much data does it need to process? You could lower the

max_threads

to reduce the memory but it slows down the queries.