We’ve recently been surprised by wrong estimates made by the planner resulting in inefficient query plans.
It seems that power law distributions over multiple tables aren’t handled very well: https://stackoverflow.com/questions/65861780/is-there-a-way-...