Optimizing PostgreSQL Indexing for High-Write Loads

Overview

High-write workloads punish naive indexing strategies. This post walks through partial indexes, fill-factor tuning, and write-amplification tradeoffs we hit in production.