KSkiran sabneinkiransabne.dev·5d ago · 7 min readPostgreSQL VACUUM: Why It Exists (and What Happens When It Falls Behind)If a table's disk size keeps climbing even though the row count hasn't — and queries against it have gotten slower for no reason you can point to — you're looking at the same root cause almost every t20
KSkiran sabneinkiransabne.dev·Aug 22 · 17 min readHow to Read a PostgreSQL Execution Plan: The Complete Guide (With Real Examples)If you've ever run EXPLAIN ANALYZE on a slow PostgreSQL query and stared at a wall of text with no idea what to do next, this guide is for you. We'll go from "what is this tree" to "here's exactly how20
KSkiran sabneinkiransabne.dev·Jan 9 · 3 min readHow do you write efficient pagination for millions of rows?Efficient pagination is absolutely critical when dealing with millions of rows in PostgreSQL — especially if you care about performance, index usage, and UX for APIs or UI pages. 1. OFFSET/LIMIT Pagin00
KSkiran sabneinkiransabne.dev·Jan 4 · 4 min readPostgreSQL Parameter Tuning for 100M+ RowsWhen you’re running PostgreSQL with 100M+ rows, the difference between “it works” and “it flies” is all about tuning—but not the generic, copy-paste advice you get everywhere. Here’s the advanced, bat00
KSkiran sabneinkiransabne.dev·Jan 3 · 4 min readUnderstanding and Solving Cache Stampede: The Invisible Threat to DatabasesImagine this: Your high-traffic app is humming along smoothly. Most data requests are being served instantly from Redis or other, blazing-fast cache layer. But then — a cache key expires, and within milliseconds, 10,000 clients hit your backend at on...00
