Hi guys, there is any recommendation for clickhous...
# supportp
Prim Mayora
02/17/2023, 12:03 AMHi guys, there is any recommendation for clickhouse mem / cpu, usage requests/limit for k8s?
Prim Mayora
02/17/2023, 12:03 AMcc @Fabio Botero Lyons
Prim Mayora
02/17/2023, 12:03 AM+ @Pranay
a
Alexei Zenin
02/17/2023, 5:59 PMI find a 32GB + 8vcpu is doing fine for hundreds of services at the moment. Anything smaller I found the quries to hang. 30 day retention roughly around 1TB+ of data
p
Pranay
02/20/2023, 4:23 AM
@Prim Mayora What scale do you have in terms of requests per second, queries per second?
p
Prim Mayora
02/20/2023, 2:23 PM~ 10/rps
a
Alexei Zenin
03/01/2023, 10:59 PMTo give more context my setup has 110 billion rows in clickhouse, average query time of 16ms and 3.5 million queries per day (alerts are based off clickhouse in an external system)