2 ms·
I find clickhouse equally simple. One command to install and then you can either read from local/remote files, create tables, etc
by higeorge13 3y ago
I find clickhouse equally simple. One command to install and then you can either read from local/remote files, create tables, etc
- winrid 3y agoFrom the brief time I used it running signoz it used a surprising amount of resources, which requires further investigation, but yes it's a nice stable option.
- glogla 3y agoClickhouse looks more complicated because instead of create table bla ( id number, xyz varchar ) you're doing things like create table bla ( id uint64 CODEC(DoubleDelta(8)), xyz Nullable(LowCardinality(Varchar)) CODEC(ZSTD(1)) ) engine=MergeTree order by id but I do wonder what is the performance difference between actually carefully specifying everything and leaving defaults (except for order by I guess).
- higeorge13 3y agoFair enough. Some of the settings will have performance impact, e.g. the low cardinality type, data skipping indexes, etc. and you have to spend some time to learn and experiment yourself. However it’s a powerful db and even the default settings will work well in the majority of cases.
- zX41ZdbW 3y agoJust leave everything by default - no need specifying any codecs, etc. People often try to show up their knowledge by using advanced features, but that's not good.