About Me

Working on PostgreSQL internals and distributed database systems.

Worked 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.

Built 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.