The postgress team is generally opposed to hints. And their reasoning sort of makes sense. When do you need a hint? why do you need a hint? If you can answer t

The postgress team is generally opposed to hints. And their reasoning sort of makes sense. When do you need a hint? why do you need a hint? If you can answer those questions wouldn't it be better to codify those answers into the query planner than a one off hint? Which nicely sidesteps how hard it actually would be to first, understand the query planner to the degree needed to change it and second, the amount of effort it would take transform a one off hint into a general purpose optimization engine.