Exploring the intersections of DBMS implementations, Operating Systems, and Computer Architecture
I am a data systems engineer with broad interests in database, open source software, and the intersection of hardware-software co-design.
How PostgreSQL fixed a critical bug where write_lag and flush_lag columns would freeze in pg_stat_replication when replay LSN stopped advancing, breaking replication monitoring during recovery conf...
Read More →How PostgreSQL gained per-backend WAL statistics visibility, enabling administrators to identify which connections generate the most WAL and diagnose write-heavy workloads with precision.
Read More →How PostgreSQL 16+ gained real-time visibility into WAL sender I/O statistics by implementing periodic statistics flushing, transforming a post-mortem tool into a live monitoring capability.
Read More →A comprehensive guide to contributing to PostgreSQL development, covering everything from motivation and setting up your environment to submitting patches, reviewing code, and engaging with the com...
Read More →A teaching operating system framework for the x86 architecture, designed to deepen understanding of OS internals through hands-on development. Over a series of labs, I implemented kernel thread scheduling with priority donation, user program loading with system calls, demand paging for virtual memory, and memory-mapped file support. Each component was built in C and tested on x86 emulators like QEMU.
Hands-on systems programming projects covering topics such as bit-level data manipulation, reverse engineering, memory hierarchy optimization, dynamic memory allocation, and network programming. Implemented a custom memory allocator, developed a Unix shell, and built a concurrent web proxy, gaining proficiency in C, debugging with GDB, and understanding low-level system operations.
Feel free to reach out for collaborations or just a chat.