There is a way to provide some type of planner hints https://pghintplan.osdn.jp/pg_hint_plan.html