war stories Scale it up, stupid! Knowledge plays a paramount role in performance management, scalability of a system, and ultimately in regulating the costs of a product. In this story, I share a failure that pushed me to increase my knowledge.
Tips & Tricks How to optimize Postgres for SELECT COUNT(*) on massive tables How to (slightly) optimize SELECT COUNT(*) performance on PostgreSQL using partial indexes.
