Partitioning in Postgres, 2022 Edition
Tracking improvements to Postgres partitioning since 2017. In just five years it’s gone from a non-feature to a very good one.
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 49,288 posts.
Tracking improvements to Postgres partitioning since 2017. In just five years it’s gone from a non-feature to a very good one.
The memory management in DOS is simple, but that simplicity may be deceptive. There are several rather interesting pitfalls that programming documentation often does not mention.
$\newcommand\of{\subseteq}\newcommand\N{\mathbb{N}}\newcommand\R{\mathbb{R}}\def\<#1>{\left\langle#1\right\rangle}\newcommand\Z{\mathbb{Z}}\newcommand\Q{\mathbb{Q}}\newcommand\ltomega{{{<}…
My current employer does a lot of really cool systems work that’s covered by NDAs. I recently did some work to integrate a cool open source tool into our workflow. Felt it deserved a blog post. NFS Testing Requires Parallelism. I work for Pure Storage. One of the products we make is a scale-out NFS1 (and…
You are seeing this because the administrator of this website has set up Anubis to protect the server against the scourge of AI companies aggressively scraping websites . This can and does cause downtime for the websites, which makes their resources inaccessible for everyone.
The following pictures show $n$ unit squares packed inside the smallest known square (of side length $s$). If a pictured packing has multiple numbers in its label above, the picture represents the largest; each smaller is represented by removing any square. For the $n ≤ 324$ not pictured, the trivial packing (with no…
To kick off MARCHintosh, I built this tiny pint-sized Macintosh with a Raspberry Pi Pico: This is not my own doing—I just assembled the parts to run Matt Evans' Pico Micro Mac firmware on a Raspberry Pi Pico (with an RP2040). The version I built outputs to a 640x480 VGA display at 60 Hz, and allows you to plug in a…
At several points throughout history, someone has sat down to watch a ballet; a long and complex performance with multiple dancers and changes of music and style, and at the end of it, said: “someh…
Photos from three very different computer museums in the Netherlands
There’s really no such thing as security in the abstract. Security can only be defined in relation to something else. You’re secure from something or against something. In the next 10 years, the traditional definition of IT security—that it protects you from hackers, criminals, and other bad guys—will undergo a…
I always got fascinated by heap memory. Questions such as How heap memory is obtained from kernel? How efficiently memory is managed? Is it managed by kernel or by library or by application itself?…
In 1994, a teenager wanted to be noticed in the ANSI art scene. So he created "Inspector Dangerfuck": a profane, stoned, gray-skinned cartoon detective.
Spring has sprung, and the smell of fresh YC applications is in the air. It’s that special time that happens twice a year where thousands…
The world's oldest complete piece of surviving music is the 3,400-year-old Hurrian cult hymn . The hymn was found inscribed on clay tablets excavated from the ancient city of Ugarit, in modern-day Syria. Sometime after the hymn was composed, the idea of using notation to record music was lost. Writing two millennia…
A little fun for the last day of 2012: how to crash a program via division? x86’s IDIV instruction traps not only on division by zero, but also on INT_MIN / -1 (signed integer overflow).
Writing an MS-DOS-compatible boot sector in C: parsing the FAT BIOS parameter block, finding IO.SYS, and loading it via BIOS INT 13h in real mode.
This post is about two new command-line utilities: rep and ren. Both are available on GitHub.
Doing anti-aliasing on SDF is not as straightforward as it seems. Most of the time, we see people use a smoothstep with hardcoded constants, sometimes with screen space information, sometimes cryptic or convoluted formulas. Even if SDFs have the perfect mathematical properties needed for a clean anti-aliasing, the…
There are two kinds of latitude: geocentric and astronomical. On a perfect sphere, they're the same, but on an oblate spheroid like Earth they're different.
To test if a display interface works we often don't want to use a huge framework like GTK or Qt. This article shows an easy way on how we can use a framebuffer directly on a DRM graphics driver under Linux.
daverowntree has one repository available. Follow their code on GitHub.