San Diego ↔ San Francisco · Postgres since 2005 · Founder of PostgresAI
🐘 Postgres · 📈 Scalability · 🌍 Open Source · 🚀 Startups
I build tools, write, and go deep on Postgres internals, performance, and operations.
- 🧵 pgque — Zero-bloat Postgres queue. No extensions. No daemon. One SQL file. A revival of PgQ, ancient art from Skype.
- 🌈 pg_ash — Active Session History for Postgres — wait event sampling with zero bloat.
- 🖥️ rpg — Modern Postgres terminal written in Rust. psql-compatible, with built-in DBA diagnostics and AI assistant.
- 🧱 sqlever — Sqitch-compatible Postgres migration tool with static analysis and zero-downtime migrations.
- 🔧 postgres_dba — Practical Postgres DBA tools for debugging, maintenance, and operations.
- 🚰 pg_plumbing — Modern Postgres dump/restore on steroids.
- 🪶 leandex — Lean index analysis for Postgres.
- 📝 samospec — Git-native CLI for multi-AI spec creation and iterative refinement.
- 🗞️ gitzette — Weekly engineering newspaper auto-generated from any GitHub user's activity (live).
Building software for self-driving Postgres.
- PostgresAI Monitoring and Checkup — Postgres observability built for humans and AI agents.
- DBLab Engine — Database branching & thin cloning for any Postgres database.
- 🎥 Postgres Hacking sessions — live deep-dives on Postgres internals on PostgresTV
- 📊 gaps.wait.events — tracking uninstrumented Postgres wait events; now a GSoC 2026 project where I'm mentoring
- 🧠 Recognized contributor to Postgres core — patches and reviews across multiple releases
- 📜 GSoC 2006 — SQL/XML 2003 support (mentored by Peter Eisentraut) — my first deep dive into Postgres internals
- ✍️ #PostgresMarathon — deep-dive series on Postgres internals
- 🎙️ PostgresFM — podcast
- 📺 PostgresTV — YouTube
- 🐦 @samokhvalov on X