zX41ZdbW

3 ms·

1.
by zX41ZdbW 7d ago
lfalloc: https://github.com/ClickHouse/ClickHouse/pull/62826 hualloc: https://github.com/ClickHouse/ClickHouse/pull/31376
2.
by zX41ZdbW 9d ago
ClickHouse has been tested with jemalloc, mimalloc, tcmalloc (both variants), rpmalloc, lfalloc, hualloc, and ended up using jemalloc after a few patches and bug fixes.
3.
by zX41ZdbW 10d ago
Some of the oldest PRs could no longer be found. For example, when I decided to continue my eight-year-old PR https://github.com/ClickHouse/ClickHouse/pull/104948 , I couldn't see it - neither in search n
4.
by zX41ZdbW 10d ago
Strange to see it here, the article is quite old. Since pdqsort, vqsort, and glide sort, the current state-of-the-art are driftsort and ipnsort. I've integrated them into ClickHouse: https://github.com/ClickHouse/C
5.
by zX41ZdbW 17d ago
I'm interested. milovidov@clickhouse.com
6.
Mostik.ai – latent communication between AI models(mostik.ai)
2 points by zX41ZdbW 20d ago|1 comments
7.
by zX41ZdbW 26d ago
Maybe share my old article with Haiku developers: https://clickhouse.com/blog/agentic-coding Could be a small chance, but it has already made many engineers reconsider their AI stance.
8.
by zX41ZdbW 28d ago
I've also built a visualizer into ClickHouse, so we can analyze its binary: https://play.clickhouse.com/binary?user=binary - which code takes more space, what dependencies are too big, or what template instantiations a
9.
by zX41ZdbW 1mo ago
ClickHouse can read and visualize its own binary: https://play.clickhouse.com/binary?user=binary It is useful to understand which dependencies, libraries, and template instantiations contribute to the size.
10.
JIT Compiling Code in 5μs(malisper.me)
167 points by zX41ZdbW 1mo ago|114 comments
11.
Solo – a .so loader for static Linux binaries(github.com)
204 points by zX41ZdbW 1mo ago|235 comments
12.
by zX41ZdbW 1mo ago
Let's add it to ClickBench: https://github.com/ClickHouse/ClickBench/
13.
by zX41ZdbW 2mo ago
If you are interested in the AIS (ship telemetry) data, my team has created a visualization project: https://adsb.exposed/?dataset=Ships&zoom=5&lat=52.3890&lng=4...
14.
by zX41ZdbW 2mo ago
This is one of the optimizations from ClickHouse - detect ASCII and go a fast path: https://github.com/ClickHouse/ClickHouse/blob/6cde32de1a2463...
15.
by zX41ZdbW 2mo ago
All databases are hosted in VMs. Most of them only support amd64, so the host machine is also amd64 - this is the only limitation. It uses hardware virtualization, so nothing is emulated.
16.
Generalized Consensus: An Alternate Approach to Distributed Durability (2025)(multigres.com)
3 points by zX41ZdbW 2mo ago|0 comments
17.
by zX41ZdbW 2mo ago
Thanks! There is a write-up: https://clickhouse.com/blog/clickbench-playground A lot of interesting things around hosting it.
18.
by zX41ZdbW 2mo ago
Thank you for Ninja! The speed (reading the build.ninja file) was never a concern for us. If I could share a wish-list, it will be: - Fix the possibility of a segmentation fault when the build file is damaged; - Use a better order of execut
19.
Show HN: ClickBench Playground – a playground for 110 database systems(benchmark.clickhouse.com)
22 points by zX41ZdbW 2mo ago|6 comments
20.
by zX41ZdbW 2mo ago
Interesting, how does it compare with StringZilla? It has highly optimized case-fold and case-insensitive Unicode search kernels as well: https://github.com/ashvardanian/Stringzilla
21.
by zX41ZdbW 2mo ago
Thanks, merged!
22.
by zX41ZdbW 2mo ago
You should submit it to ClickBench for verification.
23.
by zX41ZdbW 2mo ago
Someone ported it to ClickHouse: https://slach.github.io/CHSimCity/ Though it looks much simpler - fewer moving parts.
24.
by zX41ZdbW 2mo ago
As a coincidence, I've just integrated Cesium into my data analytics tool two days ago, https://adsb.exposed/ Though the 3D mode gives a little bit worse image quality, so I keep 2D with Leaflet as the default.
25.
by zX41ZdbW 2mo ago
ALP has been successfully integrated into ClickHouse: https://presentations.clickhouse.com/2026-release-26.3/ , though the range of scenarios when it is reasonable to choose ALP over general-purpose compression is not s
26.
by zX41ZdbW 2mo ago
Yes, for example, the datasets at this page: https://adsb.exposed/ are indexed by the Morton curve: https://github.com/ClickHouse/adsb.exposed/#database-and-que... and https://reversedn
27.
by zX41ZdbW 2mo ago
I tried pgrust on ClickBench recently, but it didn't work at all: https://github.com/ClickHouse/ClickBench/pull/983#issuecomme...
28.
by zX41ZdbW 2mo ago
I tried pgrust on ClickBench recently, but it didn't work at all: https://github.com/ClickHouse/ClickBench/pull/983#issuecomme...
29.
Shitty – A New Terminal Emulator(github.com)
2 points by zX41ZdbW 2mo ago|0 comments
30.
by zX41ZdbW 2mo ago
This is exactly what we need! Will try: https://github.com/ClickHouse/ClickHouse/issues/108247 It will be nicer if the README focuses more on per-core performance. About the actual algorithm - will something

More ›