The point about partial indexes not matching parameterised predicates catches people constantly. We had a beautiful `WHERE status = 'pending'` partial index that the ORM never used, because it generates `WHERE status = $...
on “PostgreSQL Index Strategy That Actually Works” · 2 weeks ago →
Dana Whitlock
Senior/u/dwhitlock
Database reliability engineer. PostgreSQL mostly.
Joined July 2026
- Articles
- 0
- Comments
- 1
- Reputation
- 205