-
-
Notifications
You must be signed in to change notification settings - Fork 9
ClickHouse Research
ceckoslab edited this page Jan 17, 2021
·
6 revisions
Interesting facts:
- Low cardinality column instead of an extra dimension tables
- clickhouse-local - for running queries on CSV files
- Performance (Codecs and Compression): https://youtu.be/fGG9dApIhDU?t=1735 Delat, DoubleDelta combined with Compression algorithm LZ4, ZSTD
Performance testing:
- Cache bypass
SET min_bytes_to_use_direct_io=1
in clickhouse-client before executing a query. - Control the maximum threads
SET max_threads=(?)
- Load testing instructions from this page: https://clickhouse.tech/docs/en/development/tests/ ...