Some interesting discussion starting on Reddit as well.

Notably, sir_bok says: ... it is better to be uniformly slow than to risk a performance cliff where everything seems fine until it suddenly isn't. At least uniformly bad performance (or a gradual performance decline) is predictable and can be worked around by the users. You also have more time to react.

https://www.reddit.com/r/PostgreSQL/comments/tpw6fq/new_exte...