Tips & Tricks How to optimize Postgres for SELECT COUNT(*) on massive tables How to (slightly) optimize SELECT COUNT(*) performance on PostgreSQL using partial indexes.