But that dumber query planner will bite you when your data changes. If the relative size of multiple tables change the query might have to change to be still ef

But that dumber query planner will bite you when your data changes. If the relative size of multiple tables change the query might have to change to be still efficient. Postgres query planner handles that just fine. I've used Postgres for years multi TB databases and I've experienced a problem with Postgres suddenly changing plans.