News for hackers. Stuff that matters.
Re:ClickHouse as an alternative to Elasticsearch for log sto... by wakatime on Tuesday March 02, 2021 @11:32AM (#26317058)
A related database using ideas from Clickhouse:

https://github.com/VictoriaMetrics/VictoriaMetrics

Re:ClickHouse as an alternative to Elasticsearch for log sto... by wikibob on Tuesday March 02, 2021 @12:28PM (#26317796)
Are you familiar with VictoriaMetrics?

Can you elaborate on how it is similar and dissimilar to Clickhouse?

What specific techniques are the same?

Re:ClickHouse as an alternative to Elasticsearch for log sto... by ekimekim on Tuesday March 02, 2021 @02:34PM (#26319434)
The core storage engine borrows heavily from it - I'll attempt to summarize and apologies for any errors, it's been a while since I worked with VictoriaMetrics or ClickHouse.

Basically data is stored in sorted "runs". Appending is cheap because you just create a new run. You have a background "merge" operation that coalesces runs into larger runs periodically, amortizing write costs. Reads are very efficient as long as you're doing range queries (very likely on a time-series database) as you need only linearly scan the portion of each run that contains your time range.