631
Running 10M PostgreSQL Indexes in Production
How Heap runs 10 million postgreSQL indexes in production.
Topics /
Systems & Performance
The most popular blog posts about systems & performance on Hacker News. 2,560 posts.
632
Rethinking GPS: Engineering next-gen location at Uber (2018)
Uber’s Sensing, Inference, and Research team released a software upgrade for GPS on Android phones that significantly improves location accuracy in urban environments.
633
Why we built yet another Postgres connection pooler
PgDog is a connection pooler, load balancer, and sharding proxy for PostgreSQL. Scale Postgres horizontally without rewriting your application.
634
Memcached vs. Redis – More Different Than You Would Expect
Insights from the Kablamo Engineering Team
635
636
Understanding Smallpond and 3FS
A concise breakdown of what smallpond and 3FS are, how to use them, and if they're suitable for your data processing needs.
637
638
Polars Cloud: The Distributed Cloud Architecture to Run Polars Anywhere
We introduce Polars Cloud, the distributed cloud architecture to scale and run Polars anywhere.
639
640
Erlang 19.0 Garbage Collector
Each Erlang process has its own stack and heap which are allocated in the same memory block. When the stack and the heap meet, the garbage collector is triggered and memory is reclaimed. Find out more on our blog.
641
Japan HP accidentally deleted 77TB data in Kyoto U. supercomputing system
京都大学学術情報メディアセンターセンター長 岡部 寿男
642
WASI 0.3
WASI 0.3 is official, and async is now native to WebAssembly Components. The WASI Subgroup voted to ratify WASI 0.3.0, rebasing WASI onto the WebAssembly Component Model’s async primitives. The 0.3.0 specification is now stable, and runt...
643
SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers
Transitioning SQLite from a local development tool to a production-grade database requires a deep understanding of its internal mechanics. This article explores how to tune WAL mode, manage busy handlers, and leverage custom Virtual File System (VFS) layers to achieve ultra-low latency.
644
Leveraging Rust and the GPU to render user interfaces at 120 FPS
From the Zed Blog: A deep-dive into the graphical underpinnings of GPUI, the hardware-accelerated framework that powers Zed's user interface.
645
646
647
Tricking PostgreSQL into using an insane, but faster, query plan
At Spacelift, we use PostgreSQL (specifically Aurora Serverless) for most of our primary database needs. This article will show you our optimization story and how PostgreSQL row count estimation can go very wrong.
648
649
Exploring the software that flies SpaceX rockets and starships
Spaceflight, from the beginning, has depended on computers – both on the ground and in the spacecraft. SpaceX has carried it to a new level. We recently spoke with Steven Gerding, Dragon’s software development lead, about the special challenges software development has for SpaceX's many missions.
650
We unplugged a data center to test our disaster readiness
On Thursday, November 18, 2021, Dropbox did not go down. On a normal day this would be a non-event—a sign that everything was operating as usual. However, this day was anything but usual. At 5:00 pm PT, a group of Dropboxers were huddled on a Zoom call when the command was given to physically unplug our San Jose data…
651
Exactly-once Semantics: How Kafka Does it
Exactly-once is a hard problem to solve, but we've done it. Available now in Apache Kafka 0.11, exactly-once semantics.
652
AWS Lambda Edge changes duration billing granularity from 50ms down to 1ms
Discover more about what's new at AWS with AWS Lambda@Edge changes duration billing granularity from 50ms down to 1ms
653
654
A fork() in the road
The received wisdom suggests that Unix’s unusual combination of fork() and exec() for process creation was an inspired design. In this paper, we argue that fork was a clever hack for machines and programs of the 1970s that has long outlived its usefulness and is now a liability. We catalog the ways in which fork […]
655
Making our new homepage fast and performant
This post is the third installment of our five-part series on building GitHub’s new homepage: How our globe is built How we collect and use the data behind the globe…
656
Understanding SIMD: Infinite complexity of trivial problems
A deep dive into the complexities of optimizing code for SIMD instruction sets across multiple platforms.
657
658
1BRC merykitty's magic SWAR: 8 lines of code explained in 3k words
A deep dive into merykitty's 8-line SWAR temperature parser from the One Billion Row Challenge, using bitwise tricks and ALU magic with no loops or branches.
659
Introducing the Keybase filesystem
Browse technical documentation on the public-key cryptography that powers Keybase. Learn how Keybase Chats, Files, Teams, and Git are secured.
660