Aurora PostgreSQL has something called Query Plan Management - which I like - is meant to address this type of issue especially for large tables that have key queries that you could blow up DB basically if they go haywire in planning.
Would def be a feature that would be nice to see in PostgreSQL itself.
It'd be nice if one could tell pg to only change its query plans during certain change windows, say, the first Saturday each month, with on call staff ready.
Would def be a feature that would be nice to see in PostgreSQL itself.