Skip to content

ClickHouse Research

Jump to bottom
ceckoslab edited this page Jan 17, 2021 · 6 revisions

Interesting facts:

  1. Low cardinality column instead of an extra dimension tables
  2. clickhouse-local - for running queries on CSV files
  3. Performance (Codecs and Compression): https://youtu.be/fGG9dApIhDU?t=1735 Delat, DoubleDelta combined with Compression algorithm LZ4, ZSTD

Performance testing:

  1. Cache bypass SET min_bytes_to_use_direct_io=1 in clickhouse-client before executing a query.
  2. Control the maximum threads SET max_threads=(?)
  3. Load testing instructions from this page: https://clickhouse.tech/docs/en/development/tests/ ...

Clone this wiki locally