Columnar
When Indexes Stop Helping: Columnar Engines
A systems-level look at why row-store indexes stop paying off for wide analytical scans, and where columnar execution changes the access pattern.
Medium · 21 min read
Engineering notes
Writing about backend systems, data infrastructure, and reliability.
PostgreSQL
Indexing Is Query Design, Not Column Decoration
A PostgreSQL indexing piece that reframes indexes as physical access paths for query shapes, not generic column-level speed buttons.
Medium · 15 min read
Scaling
Why Your App Slows Down When Users Increase?
A practical backend scaling note on database bottlenecks, connection pooling, caching, and measuring before optimizing.
Medium · 6 min read · Published Oct 28, 2025