@jason I asked for help on the postgresql channel, at least a workaround (you can tweak the query planner knobs so that it doesn't do this shit) and the people there were like "our query planner is perfect as it is and requires no adjustment, instead do this shit [see link]"
after that experience I've decided to not take them seriously