Most Used Storage for Clickhouse and Recommended CPU/Memory

TLDR Rohit asked about the most used storage for Clickhouse, and recommended CPU/Memory. Alexei suggested GP3, shared an older thread and an article for reference.

Photo of Rohit
Rohit
Tue, 07 Mar 2023 22:44:27 UTC

What is the most used storage for clickhouse ? Do we use gp3 or efs or fsx for lustre ? Also what is recommanded CPU/Memory for clickhouse ?

Photo of Alexei
Alexei
Tue, 07 Mar 2023 22:46:27 UTC

depends what your loads are, I use GP3 as using non-SSD seemed to perform too poorly for me.

Photo of Alexei
Alexei
Tue, 07 Mar 2023 22:46:38 UTC

See older thread about this:

Photo of Rohit
Rohit
Tue, 07 Mar 2023 22:57:40 UTC

Got it thanks, EFS seems to be slow for me, taking very very long query times

Photo of Alexei
Alexei
Tue, 07 Mar 2023 22:58:25 UTC

oh yeah for sure, EFS performance wouldn’t really scale well since its network mounted storage and not block mounted like EBS. Also it would be quite more expensive if i recall

Photo of Alexei
Alexei
Tue, 07 Mar 2023 23:00:22 UTC