Viewing profile — zX41ZdbW

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...

This is one of the optimizations from ClickHouse - detect ASCII and go a fast path: https://github.com/ClickHouse/ClickHouse/blob/6cde32de1a2463...

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 em…

Thanks! There is a write-up: https://clickhouse.com/blog/clickbench-playground A lot of interesting things around hosting it.

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 wh…

I created it mostly for testing and exploration, but the main reason was that it became possible after previous work.

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/Stringzill…

Thanks, merged!

You should submit it to ClickBench for verification.

Someone ported it to ClickHouse: https://slach.github.io/CHSimCity/ Though it looks much simpler - fewer moving parts.

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 2…

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 ov…

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://reve…

I tried pgrust on ClickBench recently, but it didn't work at all: https://github.com/ClickHouse/ClickBench/pull/983#issuecomme...

I tried pgrust on ClickBench recently, but it didn't work at all: https://github.com/ClickHouse/ClickBench/pull/983#issuecomme...

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…

Why not a wildcard DNS pointing to a few Anycast IP addresses with proxies?

https://github.com/ClickHouse/ClickBench/pull/983

Yes, it was a typo. Thank you!

https://pastila.nl/?cafebabe/5763fb6ec6db85bf0f20fbd710a8c83...