Engineering notes from a backend engineer in Nepal
A measured PostgreSQL migration at 79 GB: pg_dump and pg_restore, logical replication, and logical replication behind pgbouncer, with the cutover steps and every failure mode found along the way.
18 min read · · also on Medium
Why row-store indexes stop paying off for wide analytical scans, and how I moved those reads to DuckDB over S3-backed Parquet.
21 min read · · also on Medium
A PostgreSQL indexing piece that reframes indexes as physical access paths for query shapes, not generic column-level speed buttons.
15 min read · · also on Medium
A practical backend scaling note on database bottlenecks, connection pooling, caching, and measuring before optimizing.
6 min read · · also on Medium