NKESSLING@TERMINALSCREEN WORKOpen to work from Nov 2026RTM 22:27:52 · UTC 20:27

LOOM ~/work/loom-queue MAINTAINED

LOOM★ 1,390▼ 1.43 commits/day, 40 wkTYPESCRIPT · 2024–25

A Postgres job queue that stays fair under load

Jobs in Postgres, idempotency keys, and round-robin scheduling across tenants.

ROLE: Author · 3 contributors
STACK: TypeScript · Postgres · SKIP LOCKED
YEARS: 2024–25

COMMIT RATE · 40 WEEKS · LOOM

12k/sjobs on one node

0duplicate charges since launch

38 msp95 pickup under burst

README.md · CASE STUDY

Jobs in Postgres, idempotency keys, and round-robin scheduling across tenants.

One tenant enqueued 50,000 jobs and every other tenant waited 41 seconds for theirs. The queue was fair to jobs and unfair to people.

Design

Workers claim one job at a time with FOR UPDATE SKIP LOCKED, rotating through tenants. A unique index on tenant and idempotency key turns a retried enqueue into a no-op, which is why billing jobs never ran twice.

Numbers

The quiet tenant’s p95 pickup went from 41 seconds to 38 ms. Throughput stayed at about 12,000 jobs per second on a single node.

SCRN WORK · SCREENER6 OF 8 SHOWN

More projects.

Every project opens the same way: problem, fix, numbers.

ROLEKEY RESULT

TIDEA write-ahead log that survives the power cordtidewaterAuthor · maintainerRust2024–264,8121.92 GB/s append, one core KILNA build cache that made CI six times fasterkilnAuthorGo2023–262,2076.1x faster CI, median LOOMA Postgres job queue that stays fair under loadloom-queueAuthor · 3 contributorsTypeScript2024–251,39012k/s jobs on one node WRENRelease notes that write themselves from commitswrenAuthorTypeScript2025–261,04511 min saved per release PRSMRead traces in the terminal and diff two runsprism-traceAuthorRust2025961O(n log n) trace diff, was O(n²)FERNA small config language with typesfernAuthorZig2025–266120.4 ms compile a 2k-line config

ALL 8 PROJECTS ↗

NOTE WRITING · RESEARCH NOTES8 NOTES

Notes from the work.

Short write-ups of things that broke and how they got fixed. Plain language, real numbers.

Storage

18 SEPT 20267 min READ

You also have to fsync the directory

Why a new file is not durable until its directory is, and the crash test that proved it.

READ NOTE <GO>

30 AUG 2026Build systemsCache keys are inputs, not branch names9 min 12 JUL 2026DatabasesFair queues in Postgres, with SKIP LOCKED11 min 02 JUN 2026StorageGroup commit, drawn by hand6 min ALL NOTES ↗