Interestingly, Postgresql refuses to support query plan hints, a very popular hack on the Oracle world, because they insist if you can write a better query plan

Interestingly, Postgresql refuses to support query plan hints, a very popular hack on the Oracle world, because they insist if you can write a better query plan than the planner, you should teach the planner how to do it instead. Elegance in the long term over pragmatism of the moment.