I'm a Database Engineer at Teradata (Hyderabad, India), working on PostgreSQL internals and distributed database systems — the query planner, executor and storage engine. I care about query optimization and distributed systems, I build PostgreSQL extensions in C, developer tools in Go and Rust, and I write about what I find in the PostgreSQL source.
"The internals are where the interesting problems live."
Teradata · Sep 2026 – present
Zoho Corporation · Member Technical Staff, Jun 2023 – Sep 2026 (Project Trainee, Jan – May 2023)
| Project | What it does | Stack |
|---|---|---|
| pg_ext_memcheck | Extension that diagnoses memory bugs in other extensions — MemoryContext leaks, wrong-context allocations and shmem overruns, caught from inside the running backend. | C · PG Extension |
| pg_mcp_server | Local, offline PostgreSQL internals assistant — semantic search over the PG source, exposed as MCP tools in Zed and VS Code. Zero API cost. | Python · pgvector · Ollama · MCP |
| pg-log-parser | Parses PostgreSQL server logs, normalizes query fingerprints, and ranks the slowest queries and most frequent errors. | Rust · CLI |
| pg_join_optimizer | Statistics-driven join-order optimizer CLI for PostgreSQL. | Go · CLI |
| PG Radar · live | One dashboard for the PostgreSQL community: pgsql-hackers & pgsql-committers threads, recent commits, CommitFest patches and Planet PostgreSQL. | Next.js · React |
| db_backup_utility | CLI to back up and restore databases and automate backup jobs. | Go · Cobra |
Also: Multi-Domain Support Triage Agent (HackerRank Orchestrate hackathon — Python, Claude API, RAG) · Error Cemetery (bury fixed errors, dig them up when they return — Go, SQLite) · all projects →
Deep dives into the PostgreSQL source, verified against a running cluster — plus the full 9-module PostgreSQL Internals series.
- WAL - How PostgreSQL remembers everything it was about to do · Oct 2026
- The Anatomy of Query Structure · Aug 2026
- Vacuum - PostgreSQL way of clearing it's Debt · Aug 2026
- PostgreSQL Table Statistics: When, Where, and How They're Calculated · Jun 2026
- TableAmRoutine - your way of integrating a custom storage engine into PostgreSQL · Jun 2026
- 🏢 Settling in at Teradata — PostgreSQL internals & distributed database systems
- 🦀 Learning Rust for high-performance tooling, and going deeper into distributed systems
- 📝 Writing PostgreSQL source-code walkthroughs (next stop: the planner)
More on my /now page.
Backend & Infrastructure
Frontend
Languages
Tools
📬 Building something with PostgreSQL? Let's talk.