Hacker News: AlexClickHouse

New comment by AlexClickHouse in "Postgres rewritten in Rust, now passing 100% of the Postgres regression tests"

AlexClickHouse — Fri, 10 Jul 2026 13:19:55 +0000

Would you like to submit to ClickBench?

I can also do it if you would prefer...

New comment by AlexClickHouse in "Almost Always Unsigned"

AlexClickHouse — Thu, 09 Jul 2026 00:20:22 +0000

ClickHouse code style recommends unsigned in every case when you don't need the sign: https://clickhouse.com/docs/development/style

SWE Marathon

AlexClickHouse — Mon, 08 Jun 2026 14:04:10 +0000

Article URL: https://www.swe-marathon.org/

Comments URL: https://news.ycombinator.com/item?id=48445538

Points: 2

# Comments: 0

I Built My Own Observability for Claude Code – Here's Why and How

AlexClickHouse — Sat, 31 Jan 2026 22:07:10 +0000

Article URL: https://doneyli.substack.com/p/i-built-my-own-observability-for

Comments URL: https://news.ycombinator.com/item?id=46841389

Points: 3

# Comments: 0

Are published ANN-Benchmarks DBMS results trustworthy?

AlexClickHouse — Tue, 20 Jan 2026 11:46:25 +0000

Article URL: https://blog.ydb.tech/are-published-ann-benchmarks-dbms-results-trustworthy-f2573eca4e07

Comments URL: https://news.ycombinator.com/item?id=46690824

Points: 1

# Comments: 0

Pg_ClickHouse Postgres Extension

AlexClickHouse — Thu, 11 Dec 2025 21:24:35 +0000

Article URL: https://github.com/ClickHouse/pg_clickhouse

Comments URL: https://news.ycombinator.com/item?id=46237359

Points: 2

# Comments: 0

Amazon EC2 M9g Instances

AlexClickHouse — Sat, 06 Dec 2025 05:36:48 +0000

Article URL: https://aws.amazon.com/ec2/instance-types/m9g/

Comments URL: https://news.ycombinator.com/item?id=46171008

Points: 155

# Comments: 82

Ling-1T – a flagship non-thinking model

AlexClickHouse — Fri, 21 Nov 2025 20:46:11 +0000

Article URL: https://huggingface.co/inclusionAI/Ling-1T

Comments URL: https://news.ycombinator.com/item?id=46008783

Points: 2

# Comments: 0

Show HN: A website to compare team activity on GitHub

AlexClickHouse — Fri, 14 Nov 2025 15:51:44 +0000

Initially, I wanted to create a single report to motivate managers to look at GitHub issues. It didn't help (yet), but I got hooked and added more selectors and features to this report, making it a full-featured website, where you can compare different types of activity on different repositories, find the key team members and their contribution patterns, etc.

Source code: https://github.com/ClickHouse/velocity

(I recommend checking commit messages - I saved every single prompt as a commit)

Comments URL: https://news.ycombinator.com/item?id=45928008

Points: 2

# Comments: 0

New comment by AlexClickHouse in "Dynamic Bird Migration Map"

AlexClickHouse — Sun, 14 Sep 2025 18:40:48 +0000

I've recently implemented a similar service: https://adsb.exposed/?dataset=Birds&zoom=5 - a viewer for eBird data, where you can filter by various species and make visualizations with SQL.

Full write-up on how it is created: https://clickhouse.com/blog/birds

New comment by AlexClickHouse in "Vector database that can index 1B vectors in 48M"

AlexClickHouse — Fri, 12 Sep 2025 23:08:17 +0000

USearch is this type of library: https://github.com/unum-cloud/usearch

Used in ClickHouse and a few other DBMS.

New comment by AlexClickHouse in "Show HN: I made a small site to share text and files"

AlexClickHouse — Fri, 12 Sep 2025 23:06:03 +0000

I've implemented a similar site a few years ago, with one crucial difference, which makes it even simpler: https://pastila.nl/

The difference is that there is no "share" button, so you don't have to press it, and just copy the page URL any time.

New comment by AlexClickHouse in "SQLite's File Format"

AlexClickHouse — Sun, 07 Sep 2025 20:09:16 +0000

Exactly as in MS Access, Interbase/Firebird, and dBase II.

ClockBench – Visual Reasoning AI Benchmark

AlexClickHouse — Sun, 07 Sep 2025 20:00:48 +0000

Article URL: https://github.com/aleksafar/clockbench

Comments URL: https://news.ycombinator.com/item?id=45161628

Points: 1

# Comments: 0

Bad Muscle Memory

AlexClickHouse — Sun, 07 Sep 2025 04:30:00 +0000

Article URL: https://aborg.dev/blog/bad-muscle-memory/

Comments URL: https://news.ycombinator.com/item?id=45155402

Points: 1

# Comments: 1

EmbeddingGemma Model Card

AlexClickHouse — Sun, 07 Sep 2025 03:35:27 +0000

Article URL: https://ai.google.dev/gemma/docs/embeddinggemma/model_card

Comments URL: https://news.ycombinator.com/item?id=45155172

Points: 2

# Comments: 0

New comment by AlexClickHouse in "Parquet on Iceberg Outperforms MergeTree"

AlexClickHouse — Fri, 13 Jun 2025 21:03:26 +0000

Flawed methodology - incorrect results.

New comment by AlexClickHouse in "ClickHouse raises $350M Series C"

AlexClickHouse — Fri, 30 May 2025 18:10:18 +0000

Thanks for creating this issue, it is worth investigating!

I see you also created similar issues in Polars: https://github.com/pola-rs/polars/issues/17932 and DuckDB: https://github.com/duckdb/duckdb/issues/17066

ClickHouse has a built-in memory tracker, so even if there is not enough memory, it will stop the query and send an exception to the client, instead of crashing. It also allows fair sharing of memory between different workloads.

You need to provide more info on the issue for reproduction, e.g., how to fill the tables. 16 GB of memory should be enough even for a CROSS JOIN between a 10 billion-row and a 100-row table, because it is processed in a streaming fashion without accumulating a large amount of data in memory. The same should be true for a merge join.

However, there are places when a large buffer might be needed. For example, if you insert data into a table backed by S3 storage, it requires a buffer that can be in the order of 500 MB.

There is a possibility that your machine has 16 GB of memory, but most of it is consumed by Chrome, Slack, or Safari, and not much is left for ClickHouse server.

New comment by AlexClickHouse in "ClickHouse gets lazier and faster: Introducing lazy materialization"

AlexClickHouse — Mon, 28 Apr 2025 18:49:53 +0000

ClickHouse predates Apache Arrow.

New comment by AlexClickHouse in "You might want to stop running atop"

AlexClickHouse — Wed, 26 Mar 2025 03:32:14 +0000

I vaguely remember an old bug in atop, leading to a very unusual consequence.

Atop will do an invalid memory write and crash with a segfault. But this writing is performed on a memory page mapped to a hardware timer. Despite not being able to write into that page, just touching it somehow changes how this hardware timer works. Then, the OS detects that this timer is inaccurate and switches to a different clock source (which you can see in /sys/devices/system/clocksource/clocksource0/current_clocksource). As a result, every call to clock_gettime becomes slower, and the system becomes slower as a whole until it restarts.

In short, a segfault in atop leads to the whole system's performance degradation. But this was found around maybe 7 years ago.