4 ms·
ClickHouse vs TimescaleDB
- rkwasny 5y agoIt's really quite easy, if you don't need DELETE ClickHouse wins every benchmark.
- qoega 5y agoYou can use clickhouse/clickhouse-server image. It has 21.10 version: https://hub.docker.com/layers/clickhouse/clickhouse-server/21.10.2.15/images/sha256-740961cfa56dcca5bccdd89eff581ca5c7ea8123faba593bba47a38960b197b3?context=explore https://hub.docker.com/layers/clickhouse/clickhouse-server/2...
- qoega 5y agoIt will probably be even faster: > clickhouse-client --time --query "INSERT INTO rides FROM INFILE 'nyc_data_rides.csv' FORMAT CSV;"
- qoega 5y agoThe rest of the queries https://gist.github.com/qoega/32c4f54da6b0324aef8cd8d910dd7c7f https://gist.github.com/qoega/32c4f54da6b0324aef8cd8d910dd7c...
- pradeepchhetri 5y agoThank you for doing this. Will you mind if I include this my blog by mentioning your help in my post.
- qoega 5y agoYou can add even without mentioning. I did almost nothing - it worked almost without diff.
- pradeepchhetri 5y agoThank you so much :)