· 5 min read
The pgvector index nobody measured
Vector search in Postgres degrades quietly. The index crosses RAM, the build runs on disk, recall decays with churn, and none of it raises an alert.
Read the post →
Blog
Engineering notes from the people building Postgres Autopilot
What we built, the parameters behind it, and the trade-offs we chose. No listicles.
- #action-plane
- #anomaly-detection
- #aurora
- #governed-autonomy
- #high-availability
- #machine-learning
- #monitoring
- #pgvector
- #plan-regression
- #policy-gate
- #postgres-18
- #postgres-internals
- #query-plans
- #signatures
- #vector-search
- All topics
· 5 min read
Aurora's writer endpoint can lie to you
CloudWatch measures instances. Your application talks to endpoints. For the minute those disagree, every instance metric looks healthy while writes fail.
Read the post →
· 5 min read
PostgreSQL 18 moved the WAL I/O counters
pg_stat_wal lost its write and sync columns to pg_stat_io in 18. Nothing errors. The numbers just stop arriving, and most monitoring never notices.
Read the post →
· 5 min read
Why we capped ourselves at rung 2
We built an action plane and a fail-closed policy gate, then refused to let any action run unattended until it could prove it was reversible. The ladder.
Read the post →
· 5 min read
75% of our query-plan storage was duplicate
Thousands of stored plans turned out to be a few hundred distinct shapes. What a structural fingerprint keeps, what it strips, and why regressions depend on it.
Read the post →
· 6 min read
What our anomaly engine actually runs
An isolation forest with a fixed contamination rate, density clustering with a sample floor, a threshold-ladder classifier, and heuristics that name a cause.
Read the post →
Postgres notes, roughly monthly
One email when we publish: what we built, the parameters behind it, and the trade-off we chose. No drip campaign, unsubscribe in one click.
Posts are dated and argue a position. For undated reference on one problem at a time, with the queries to run against your own cluster, see the learn guides. Everything published on this site, posts and guides and calculators alike, is listed by date on the changelog.
Written by Karthik M; who we are and why Postgres only. Subscribe with RSS, JSON Feed, or the Postgres-only feed that leaves out anything about us. Each topic has its own feed as well.
Put every Postgres you run on autopilot.
We onboard teams in small batches. Tell us about your fleet and we will reach out when a seat opens. One email, no drip campaign.