Summary
Database Engineer working on PostgreSQL internals — the query planner, executor and storage engine. I care about query optimization and distributed systems, and I build developer tools in Go and Rust.
Open Source
PostgreSQL Core — Authored a patch adding an extension hook into ANALYZE's sample-row acquisition path, enabling plugins to supply custom sampling strategies for statistics collection; currently under community review in Commitfest PG20-1 (target: PostgreSQL 20). commitfest.postgresql.org/patch/6939
Experience
AI Engineer (Database & PostgreSQL Internals)
September 2026 – PresentWorking on PostgreSQL internals and distributed database systems.
Member Technical Staff
June 2023 – September 2026Worked on the core of Zoho's distributed PostgreSQL — the planner, executor, COPY framework and connection management — with a focus on correctness, scalability and performance.
- Worked extensively on core PostgreSQL internals including the Planner, Executor, COPY framework, and connection management to support custom distributed database architectures, ensuring correctness, scalability, and high performance.
- Architected a cross-shard statistics aggregation pipeline that propagates shard-level statistics to coordinator-level PostgreSQL statistics, enabling the query planner to make accurate cardinality estimates and optimize repartition strategies.
- Replaced bulk shard-metadata caching with a lazy, incrementally-populated key-cache system, eliminating a 200ms+ cold-start penalty on initial connections and reducing p99 insert latency by 8x (from 200ms to 25ms).
- Engineered cross-engine query features that enabled external database nodes (e.g., MySQL) to register under a PostgreSQL coordinator, facilitating transparent query execution across heterogeneous environments.
- Optimized data transfer pipelines using efficient serialization and compression techniques, achieving up to a 5x performance improvement in overall query execution.
- Designed high-performance pagination systems to eliminate OFFSET-based performance bottlenecks and executed zero-downtime database migrations using blue-green deployment strategies to ensure uninterrupted production traffic.
Project Trainee
January 2023 – May 2023Built a query-statistics PostgreSQL extension to learn the internals and get familiar with the codebase.
- Designed and implemented a PostgreSQL extension that hooks into the query planner to count the queries executed against each table.
- Used PostgreSQL hooks to intercept each query's type and record counts in a custom stats table that users can query for insight into access patterns.