Why strict memory overcommit matters for Postgres

kept by sagevieve sep 27

ClickHouse Managed Postgres enables strict memory overcommit so that out‑of‑memory conditions fail a single query instead of triggering an instance‑wide OOM restart, with no measurable throughput loss.

I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code
PostHog's engineer used parallel Claude Code sessions to rewrite their SQL parser, achieving a 70x speedup by fuzzing against the old ANTLR-based parser as an oracle.
also on ClickHouse, #performance, #developer-tools
Revisiting Joel's Test - exe.dev blog
Joel Spolsky's original twelve‑question Joel Test remains valid, but nine additional agent‑focused questions form the Shelley Test for modern software teams.
also on ClickHouse, #developer-tools
AI inference just plays by different rules
AI inference workloads demand unprecedented concurrency and throughput, exposing cloud storage limits that require a decoupled, software-defined layer to avoid catastrophic failures.
also on PostgreSQL, #performance, #cloud-computing
Introducing TIN: full-text search for Postgres — PlanetScale
PlanetScale announces TIN, a Postgres full‑text search extension that outperforms existing indexes with up to 57× higher query throughput and lower latency.
also on PostgreSQL, #performance, #developer-tools