PostgreSQL Nested Loop: When Is It Actually a Problem?When a Postgres Nested Loop join is fine vs. when outer rows × inner loops actually costs you — real EXPLAIN ANALYZE examples.3 min read·kiransabne.dev1Sep 18
PostgreSQL Index Bloat: Why It Happens and How to Fix ItWhy PostgreSQL indexes bloat even after VACUUM, how to measure it with pgstatindex, and when to use REINDEX CONCURRENTLY or pg_repack to fix it.6 min read·kiransabne.devSep 18
PostgreSQL VACUUM: Why It Exists (and What Happens When It Falls Behind)How PostgreSQL's MVCC creates dead tuples, what VACUUM actually does, why autovacuum falls behind, and how to tune it before bloat and wraparound hit.7 min read·kiransabne.dev2Aug 25
How to Read a PostgreSQL Execution Plan: The Complete Guide (With Real Examples)Learn to read PostgreSQL execution plans step by step. EXPLAIN ANALYZE, node types, buffers, and real production examples17 min read·kiransabne.dev2Aug 22
How do you write efficient pagination for millions of rows?Learn efficient pagination for PostgreSQL to optimize API, UI, and high-concurrency performance3 min read·kiransabne.devJan 9