frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

How to ingest 1B rows/s in ClickHouse

https://www.tinybird.co/blog-posts/1b-rows-per-second-clickhouse
32•_peregrine_•5mo ago

Comments

trollied•5mo ago
From yesterday https://news.ycombinator.com/item?id=44933452
_peregrine_•5mo ago
definitely interesting and related
jandrewrogers•5mo ago
I don't know about ClickHouse specifically but these days it isn't that hard to ingest >10M rows/sec per server, including parsing, processing, indexing, and storage. You can just throw hardware at it.
_peregrine_•5mo ago
yeah I mean that's basically what Javi talks about in the post... if you can throw hardware at it you can scale it (ingestion scales linearly with shards)

but the post has some interesting thoughts on how you do the high-scale ingestion while also handling background merge processes, reads, etc.

jauntywundrkind•5mo ago
Minor quibble but: probably get another 5-15% by upgrading from oldoldstable Debian 11/Bullseye with kernel 5.10 to something modern like Debian 13/Trixie.

Edit: oh these are containers, right; the difference will be far less since the kernel is determined by the host. Still, I find it sad to see old software versions like this used.

_peregrine_•5mo ago
nice one
javisantana•5mo ago
Thanks.

I re-used all scripts and didn't even notice the linux version.

logifail•5mo ago
> probably get another 5-15% by upgrading from oldoldstable Debian 11/Bullseye with kernel 5.10 to something modern like Debian 13/Trixie

For the on-prem/homelab crowd: I upgraded my desktop from Debian 12 to 13 yesterday only to discover my Mellanox ConnectX-3 NIC wasn't supported by the Trixie kernel. From 10GbE to 0GbE in one reboot :/

Have ordered a ConnectX-4 so that should get me going again, of course 100GbE is severe overkill for my needs but since I already have a 100GbE switch I figured why not...

rognjen•5mo ago
Is it just me or is there a noticeable uptick in Clickhouse related posts that are border-line marketing?
coolspot•5mo ago
ClickHouse is just awesome and underrated. I tried to use TimeScale DB for 1-minute stock prices, and it was super slow and inefficient. On ClickHouse, the same data works, and it is blazingly fast.

Show HN: Engineering Perception with Combinatorial Memetics

1•alan_sass•40s ago•1 comments

Show HN: Steam Daily – A Wordle-like daily puzzle game for Steam fans

https://steamdaily.xyz
1•itshellboy•2m ago•0 comments

The Anthropic Hive Mind

https://steve-yegge.medium.com/the-anthropic-hive-mind-d01f768f3d7b
1•spenvo•2m ago•0 comments

Just Started Using AmpCode

https://intelligenttools.co/blog/ampcode-multi-agent-production
1•BojanTomic•3m ago•0 comments

LLM as an Engineer vs. a Founder?

1•dm03514•4m ago•0 comments

Crosstalk inside cells helps pathogens evade drugs, study finds

https://phys.org/news/2026-01-crosstalk-cells-pathogens-evade-drugs.html
2•PaulHoule•5m ago•0 comments

Show HN: Design system generator (mood to CSS in <1 second)

https://huesly.app
1•egeuysall•5m ago•1 comments

Show HN: 26/02/26 – 5 songs in a day

https://playingwith.variousbits.net/saturday
1•dmje•6m ago•0 comments

Toroidal Logit Bias – Reduce LLM hallucinations 40% with no fine-tuning

https://github.com/Paraxiom/topological-coherence
1•slye514•9m ago•1 comments

Top AI models fail at >96% of tasks

https://www.zdnet.com/article/ai-failed-test-on-remote-freelance-jobs/
3•codexon•9m ago•1 comments

The Science of the Perfect Second (2023)

https://harpers.org/archive/2023/04/the-science-of-the-perfect-second/
1•NaOH•10m ago•0 comments

Bob Beck (OpenBSD) on why vi should stay vi (2006)

https://marc.info/?l=openbsd-misc&m=115820462402673&w=2
2•birdculture•13m ago•0 comments

Show HN: a glimpse into the future of eye tracking for multi-agent use

https://github.com/dchrty/glimpsh
1•dochrty•14m ago•0 comments

The Optima-l Situation: A deep dive into the classic humanist sans-serif

https://micahblachman.beehiiv.com/p/the-optima-l-situation
2•subdomain•14m ago•0 comments

Barn Owls Know When to Wait

https://blog.typeobject.com/posts/2026-barn-owls-know-when-to-wait/
1•fintler•15m ago•0 comments

Implementing TCP Echo Server in Rust [video]

https://www.youtube.com/watch?v=qjOBZ_Xzuio
1•sheerluck•15m ago•0 comments

LicGen – Offline License Generator (CLI and Web UI)

1•tejavvo•18m ago•0 comments

Service Degradation in West US Region

https://azure.status.microsoft/en-gb/status?gsid=5616bb85-f380-4a04-85ed-95674eec3d87&utm_source=...
2•_____k•18m ago•0 comments

The Janitor on Mars

https://www.newyorker.com/magazine/1998/10/26/the-janitor-on-mars
1•evo_9•20m ago•0 comments

Bringing Polars to .NET

https://github.com/ErrorLSC/Polars.NET
3•CurtHagenlocher•22m ago•0 comments

Adventures in Guix Packaging

https://nemin.hu/guix-packaging.html
1•todsacerdoti•23m ago•0 comments

Show HN: We had 20 Claude terminals open, so we built Orcha

1•buildingwdavid•23m ago•0 comments

Your Best Thinking Is Wasted on the Wrong Decisions

https://www.iankduncan.com/engineering/2026-02-07-your-best-thinking-is-wasted-on-the-wrong-decis...
1•iand675•23m ago•0 comments

Warcraftcn/UI – UI component library inspired by classic Warcraft III aesthetics

https://www.warcraftcn.com/
1•vyrotek•25m ago•0 comments

Trump Vodka Becomes Available for Pre-Orders

https://www.forbes.com/sites/kirkogunrinde/2025/12/01/trump-vodka-becomes-available-for-pre-order...
1•stopbulying•26m ago•0 comments

Velocity of Money

https://en.wikipedia.org/wiki/Velocity_of_money
1•gurjeet•28m ago•0 comments

Stop building automations. Start running your business

https://www.fluxtopus.com/automate-your-business
1•valboa•33m ago•1 comments

You can't QA your way to the frontier

https://www.scorecard.io/blog/you-cant-qa-your-way-to-the-frontier
1•gk1•34m ago•0 comments

Show HN: PalettePoint – AI color palette generator from text or images

https://palettepoint.com
1•latentio•34m ago•0 comments

Robust and Interactable World Models in Computer Vision [video]

https://www.youtube.com/watch?v=9B4kkaGOozA
2•Anon84•38m ago•0 comments