Yes
It got the query down from 5+ minutes to a few seconds
Atotalnoob on Hacker News
5+ minutes to a few seconds
In the thread “Looking Forward to Postgres 19: Query Hints”, replying to this comment
Helped: Providing local data and requiring unit tests for verification.
… Then I told opus how to get the raw SQL and told it to write unit tests with various optimizations. It got the query down from 5+ minutes to a few seconds. I verified the final SQL and ORM structure. …