I don't know about ClickHouse specifically but these days it isn't that hard to ingest >10M rows/sec per server, including parsing, processing, indexing, and storage. You can just throw hardware at it.
Minor quibble but: probably get another 5-15% by upgrading from oldoldstable Debian 11/Bullseye with kernel 5.10 to something modern like Debian 13/Trixie.
Edit: oh these are containers, right; the difference will be far less since the kernel is determined by the host. Still, I find it sad to see old software versions like this used.
ClickHouse is just awesome and underrated.
I tried to use TimeScale DB for 1-minute stock prices, and it was super slow and inefficient. On ClickHouse, the same data works, and it is blazingly fast.
6 comments
[ 31.8 ms ] story [ 247 ms ] threadEdit: oh these are containers, right; the difference will be far less since the kernel is determined by the host. Still, I find it sad to see old software versions like this used.