hi all, I am trying to figure out if there's a way to use more ram to allow faster queries or less cold load of data maybe? Currently using ~15GB of ram, and have 100GB of ram sitting around. Maybe my understanding of the architecture is flawed, so let me know if thats the case, but im simply trying to throw ram at the system anywhere it can use it.

self-hosted ?

@Abdelkader Boudih yes

You have it capped in docker ? Mine use all ram of the instance.

no. no cap.

While memory helps to avoid re-reading the data, it alone doesn't speed up all queries, speed of a query depends on the number of cores available and disk read speed.

E5-2695 v4 x 2 (36 cores / 72 thread) enterprise NVME drives

When you run the query what the read speed

Btop shows 26M/s read speeds. if there's something else or somewhere else I should look for this answer please let me know.

I was asking to run the query and see the query speed from clickhouse client