PostgreSQL Query Anti-Patterns and Common Mistakes

If you've ever been called in to look at a slow PostgreSQL database, you've probably noticed that the same handful of patterns show up again and again. Most queries aren't slow because they're subtle or because the planner made a creative mistake — t...