Postgres: Recreating Indexes supporting Unique, Foreign Key and Primary Key Constraints

I have frequently found myself in situations when I had to reindex a few indexes (because the index got bloated a lot), and I always have to lookup the exact commands, after searching quite a bit, just to be sure that I am doing the right thing and not making a mistake. In the past, … Continue reading Postgres: Recreating Indexes supporting Unique, Foreign Key and Primary Key Constraints

Avoid breaking habits with help from Economics

Recently, while reading "How Will You Measure Your Life?", I came across the concept of Marginal Thinking and I thought that it could be used as a mental model for motivating people who struggle with building new habits (like this guy I know, me). Aside: I highly recommend reading "How Will You Measure Your Life?" … Continue reading Avoid breaking habits with help from Economics

Don’t be the Alpha Geek: Your team deserves better

Alpha Geek? I recently came across the term “Alpha Geek” in “The Manager’s Path”. The Alpha geek is usually an excellent, effective engineer who is driven to always have the right answers, and solve hard problems. Alrighty! I want to be one! Where do I sign up? He knows exactly why that thing you’re trying … Continue reading Don’t be the Alpha Geek: Your team deserves better