Hacker News new | ask | show | jobs
by sgarland 819 days ago
IME, many query flips occur due to inadequate analysis, inadequate vacuuming, or table / index bloat.

Examining statistics for your tables / indices can be quite helpful in determining the issue.