Blog

Thoughts & Stories

Sharing my experiences, learnings, and adventures in tech and beyond.

Browse by Topic

DevOps & Cloud Infrastructure (138)AI & LLMs (102)Web Development (81)ERP Systems (72)Backend & APIs (60)Software Development (52)Security (28)Career Reflections (27)Cloud (15)Product & SaaS (12)AI / Machine Learning (5)University (1)Hackathons (1)

Reading PostgreSQL EXPLAIN ANALYZE Like a Pro

Backend

July 20269 min read

Reading PostgreSQL EXPLAIN ANALYZE Like a Pro

How I read PostgreSQL EXPLAIN ANALYZE output: seq scan vs index scan, nested loop vs hash join, buffers, and how to find the node that is actually slow.

PostgreSQL Generated Columns for Computed Data

Backend

July 20269 min read

PostgreSQL Generated Columns for Computed Data

When to push derived logic into STORED generated columns, how to index them, and the constraints that bite you in production.

Zero-Downtime PostgreSQL Major Upgrades with Logical Replication

Backend

July 20269 min read

Zero-Downtime PostgreSQL Major Upgrades with Logical Replication

How to move a live PostgreSQL database to a new major version with sub-second downtime using publications and subscriptions — and the sequence, large-object, and DDL gaps that will bite you at cutover if you forget them.