The pg_hint_plan extension isn't in core, yet is pretty competent when you need to override planner.