Mixed
Would have taken days or weeks for me to figure that out on my own
nijave on Hacker News
massive 100x+ improvement
In the thread “Looking Forward to Postgres 19: Query Hints”, replying to this comment
Helped: Interpreting plans and finding rare planner predicate limitations.
Got in the way: Rewriting Django ORM queries with large structural changes instead of surgical fixes.
… out I was hitting a planner predicate comparison limitation where switching from "bool = false" to "not bool" or maybe the other way around led to a massive 100x+ improvement (the planner was skipping using an index because the predicate in the query didn't "match" the predicate in the partial index despite the conditions being logically equivalent) Would have taken days or weeks for me to figure that out on my own