Last year we hit a case. PG 17.1 broke the ABI during a minor upgrade. That broke certain extensions, including TimescaleDB. In response, some maintainers switched to building for every PG minor version. But that creates new problems. If you build for every single minor version, in-place upgrades become much harder. It's better to treat this as an exceptional case. But we have to be ready for it when it happens.
Part IV Maintenance in the Wild
PG Minor ABI Break
PIGSTY
SHOULD WE BUILD THE EXTENSION FOR EACH MINOR POSTGRESQL VERSION?